Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Application optimization question
Ah - one of those "it depends" things - I gotcha. Thanks for the help. James -
Application optimization question
Ideally yes, but my database doesn't support transactions. -
SOS. select from many tables which has the same structure
SwampBoogie was right. If you index the tables properly, the size won't matter. If you're doing queries like hotel_date BETWEEN "2001-01-04" AND "2001-01-08", it should actually be faster since it won't have to search the whole month. But if you've already got the code... -
Application optimization question
Hi all. I'm on about my third database application and I've started thinking about optimization. At the moment, this question is academic, as the database is small and either of my two alternatives will work equally well. I just want to better understand how to optimize. Basically my...
