Re: Optimizing oracle 8 table/tablespace (to slow)

We have WEB sites with 25.000.000 rows. And they run like a dream, with subsecond response times on normal x86 boxes with SCSI drives. So your problem is probably the design of the database (schema) and the queries that run on the schema.

Do you use indexes ?
Primary keys on all tables ?

Optimizing tablespaces etc. should only be required on large tables, and 200 rows is a very tiny table.

How much memory does your webserver have etc. ?

Ted

On Wed, 3 Jan 2001 17:10:57 +0100, Kim Ammouche <kim_at_ammouche.net> wrote:

>Hi there.
>
>I got some websites runnting oracle and a web application generating
>pages from the database. The application runs just fine when the
>database has 0-200 rows. Then it starts slowing down the more rows are
>added. I have optimized the SQL as good as it can get for now.
>
>And was wondering if there is anything to be done with the database to
>get it to move faster. Anyway of optimizing the tables, tablespaces etc
>?
>
>Otherwise a hardware upgrade is required...
>
>Best Regards - Kim

EMail: knijff_at_bigfoot.com Received on Wed Jan 03 2001 - 11:51:20 CST