RE: Table Sizes

Hi Bill,

You don't need to write your own software, you could explore the use of
MERGE tables (available at 4.?) but if you can hang out for a little
while, version 5.1 has a new scheme named partitioning that has greater
functionality and maybe what you are looking for.

For the moment though,
http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html may be
the way to go. This is totally independent from the DBI/DBD perl modules
so shouldn't affect any of your scripting. This is also available at
version 4.?

Regards


---------------------------------------------------------------
********** _/     **********  David Logan 
*******   _/         *******  ITO Delivery Specialist - Database
*****    _/            *****  Hewlett-Packard Australia Ltd
****    _/_/_/  _/_/_/  ****  E-Mail: [email protected]
****   _/  _/  _/  _/   ****  Desk:   +618 8408 4273
****  _/  _/  _/_/_/    ****  Mobile: 0417 268 665
*****        _/       ******    
******      _/      ********  Postal: 148 Frome Street,
********   _/     **********          Adelaide SA 5001
                                      Australia 
i    n    v    e    n    t                                   
---------------------------------------------------------------

-----Original Message-----
From: Bill Platt [mailto:[email protected]] 
Sent: Friday, 17 February 2006 9:17 AM
To: [email protected]
Subject: Table Sizes

I am wondering which is most effective.

Setting up a table with smaller pieces and
writing the software to search smaller tables,
OR
setting up one big table with all of the related
data inside of it?

I have a mysql database I am working with
that has 32 million records in it. I am wondering
if I would be better off to somehow break that
data into much smaller pieces so that there are
fewer rows, or whether it is just as effective to
keep everything in one table.

Maybe I should break it down alphabetically
or something.

The reason for my concern about this is when
I access the database through phpMyadmin, every
request takes  long time to load up. Even minor
changes seem to be a real pain in the you know
what.

Speed within the site is of vast importance to me.

Thanks for your advice.

Bill


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]