Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: DBI speed up needed on MySQL

by zgrim (Friar)
on May 09, 2005 at 20:28 UTC ( #455308=note: print w/ replies, xml ) Need Help??


in reply to DBI speed up needed on MySQL

On the iron and adminspotting side I would recommend some of this and such reading. Hints: key_buffer size in server config file, optimize table maintainance, memory resources, etc.
On the coding side, I don't really think using arrayref over hashref would be much of an optimization, and this kind of tricks. Still, using select * from table is kindof a php thing (sorry, i couldn't resist). :)
Proper indexes and LIMIT statements will prolly speed things if it is really too late for database proper redesign.

... imho :)
--

perl -MLWP::Simple -e'print$_%%\n|,<br /> get(q=http://cpan.org/misc/japh=)))'


Comment on Re: DBI speed up needed on MySQL

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://455308]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (7)
As of 2014-10-23 04:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (123 votes), past polls