|
|
|
| more useful options | |
| PerlMonks |
Re: fastest method to use DBIby BrowserUk (Patriarch) |
| on Jul 07, 2009 at 07:03 UTC ( [id://777760]=note: print w/replies, xml ) | Need Help?? |
|
The whole point of a SELECT statement is to select (only) the records you need! If you truly cannot do with anything less that the whole 100,000 rows, and if you need to reload them often enough that the load performance is a problem, then you would be better storing them (or cacheing) them somewhere that does not carry the overhead of the DB select and communications--eg. a file. Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||||||||