Re: Db Efficiency

2001-04-03 Thread Steve Werby
"Ashley M. Kirchner" <[EMAIL PROTECTED]> wrote: > If I list 15 to 30 > projects per page, that's 31 to 61 queries for one page: once to the > projects table to get the projects, then for each project I make two > queries, one to the history table and one to the comments table to get > the accurate

Db Efficiency

2001-04-03 Thread Ashley M. Kirchner
I have a DB that (for the purpose of this email) contains three tables: projects, comments, and history. Each project will have its set of comments added, and as the project advances over time, also its set of history items. This information gets displayed on a web page roughly in the f