Ben Heuer wrote:
It is impossible to give any correct response for your question if we
don't see your query.
By the way, see how to limit the number of joins between your two tables
Other wise it may be 34000 * 17000 (instead of 3000 * 3000) joins and
your database server will use secondary memory so very costly in speed.
>
> Hello all,
>
> I have two tables which I am joining inside my SQL and everything works
> like an express train when these tables have 3000 records each. Now
> when I have 34000 and 17000 records respectively, it is VERY slow
> (takes half a minute to even begin to return the resultset!)
>
> All the indices are in place!
>
> I would really be obliged if someone could tell me what I can do to
> increase the speed! Is there a site I can visit that tells me how to
> "tune" the database?
>
> Thanks a lot in advance!
> Ben
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Sun Dec 12 1999 - 10:01:17 CST
