in reply to Re: Need faster MySql data fetching with perl DBI
in thread Need faster MySql data fetching with perl DBI

Well you all, I must thank you once again. I stayed up reading about indexes and this morning I implemented them for all of my WHERE clauses. Wouldn't you know, that 20 to 25 second search I was talking about, well it is down to basically nothing now. It's instant on the website. Thanks so much for all the help.

Replies are listed 'Best First'.
Re^3: Need faster MySql data fetching with perl DBI
by beable (Friar) on Jul 17, 2004 at 00:10 UTC
    Now you better read up on MySQL security. If you didn't know about indexes, then chances are that you don't know about database security either.