Re: Table Sizes

Hi,

On Thu, 16 Feb 2006 23:47:29 +0100, Bill Platt wrote:
...
> I have a mysql database I am working with that has 32 million records in it.
...
> Maybe I should break it down alphabetically or something.

This goes against the meaning of using SQL server - it optimizes this itself.

...
> The reason for my concern about this is when I access the database through
> phpMyadmin,

I do not use phpMyadmin myself, I find mysql(1) client more comfortable.
Still: Do you really have the SQL indexes properly setup even for the accesses
by phpMyadmin? The time is consumed by MySQL or phpMyAdmin (httpd/PHP)?
You can also access query limited by parts FIELD like 'f%' without modifying
the tables structure, can't you? Sure the proper index should be setup and this
approach would be definitely just a phpMyadmin workaround.

Sorry for not knowing the phpMyadmin problems myself, I find you should even be
able to use mysql-query-browser and mysql-administrator as GUI interfaces.


Regards,
Lace

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