Hi All
At 11:17 PM 6/6/2002 -0700, Jeremy wrote:
> > However, there is the occasional "select" query that requires a good
> > amount of work on the database.
>
>Why? Can it be optimized?
The query is needs about 10 left joins, and requires data from about 12
different tables (some tables have
On Thu, Jun 06, 2002 at 02:24:06PM -0700, Matt Rowe wrote:
> Dear list,
>
> After doing a good bit of reading, the details are still hazy.
>
> I have a web-based application (about 20 tables, with up to 100,000
> records per table - but most tables are much smaller). 99% of
> "select" queries a
Dear list,
After doing a good bit of reading, the details are still hazy.
I have a web-based application (about 20 tables, with up to 100,000 records
per table - but most tables are much smaller). 99% of "select" queries are
very very fast.
However, there is the occasional "select" query tha