Re: creating tablespaces for performance
Date: 10 Sep 2002 22:56:09 -0700
Message-ID: <396cc940.0209102156.919a9d_at_posting.google.com>
I don't have information about the setup because the database is
hosted onto a different web server.
The performance issue comes whenever I try to access those two tables.
Even a simple select query takes quite a lot of time; and for my
application's purpose I need to take join of both the tables. As far
as other tables are concerned, I am able to run almost any type of
queries without much of the delay.
To be more precise, I had created an ASP application which was workin
fine till the data tables had only 10k records, but as the size of
these tables grew the application started timing out. Later I found
that simple queries like "select distinct name from table1" times out
when queried through application but gives me results when queried
through Oracle client with slight delay. That indicates that I may
have to do certain exercise on the ODBC layer also... still I would
always like to fine tune my database end as much as possible.
Now returning to my original question, "Does keeping larger tables in
seperate tablespace improve performance?"
Regards,
Anand
Received on Wed Sep 11 2002 - 07:56:09 CEST