Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

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='

Comment on Re: DBI speed up needed on MySQL

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2015-11-30 07:19 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (763 votes), past polls