[Jax.PM] MySQL ?

[William C. (Bill) Jones]

Sorry for the late reply - tonight is my teaching night :/

:)

See below -

On Thursday, October 17, 2002, at 11:18  AM, Aaron Johnson wrote:

> How big are your tables?
> How many tables do you have?
> What type of queries are you doing?
> Are you running under mod_perl?
> If you are under mod_perl have you put Apache::DBI in your startup.pl?
>
> If it is a CGI model app have you looked at
> CGI::Speedyhttp://search.cpan.org/author/HORROCKS/CGI-
> SpeedyCGI-2.21/lib/CGI/SpeedyCGI.pm
>
> I have used CGI::Speedy in a couple of apps and seen an improvement in
> performance, but not sure if it would reuse DBI connection, most likely
> they would be reestablished on each call so not sure how that 
> would help
> your MySQL specific question.


The main table size is about 100 fields, I have 40 tables, the 
median ISAM file size if ~400MB I have a total of ~12,000 student 
records occupying - to one degree or another - ~540 on-line 
courses...  The complete dataset is ~17GB...

I don't feel that any of this is so special as to cause the system 
to "drag" with each query; so I have been trying to get management 
to purchase $2-3,000 worth of MySQL/Perl consulting to see if I 
have really missed anything or is the b system truly this awful?

:)  My money is the Bb system is truly awful...
-Sx-