|
|
|
| Keep It Simple, Stupid | |
| PerlMonks |
Re: Re: Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCEby etcshadow (Priest) |
| on Nov 14, 2003 at 17:59 UTC ( [id://307235]=note: print w/replies, xml ) | Need Help?? |
This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.
Yeah, there are lots of good examples... I was just trying to come up with the very simplest query that would demonstrate the problem.
Honestly, single-table queries aren't likely to be all that problematic, no matter what. You do a full table-scan on a million-row table... well, that's 5 seconds you wish you hadn't spent, but it's not gonna totally kill you, unless it is being hit with great frequency. It's really when you get into large, complicated plans involving lots of joins and various other nasties, that tuning gets to be really critical (except, of course, for very frequently accessed queries). Somebody could write a whole book on database tuning... oh, wait... several people already have :-P ------------ :Wq Not an editor command: Wq
In Section
Meditations
|
|
||||||||||||||||||||||||