Re: Speeding Intermedia Query
Date: Tue, 30 Sep 2003 02:40:24 GMT
Message-ID: <s26eb.374822$2x.114896_at_rwcrnsc52.ops.asp.att.net>
"Angel Faus" <afaus_at_corp.vlex.com> wrote in message
news:7a7a07a.0309290938.410c010c_at_posting.google.com...
> Hi all,
>
> We've got an Oracle database in a Web application. Intermedia Text
> queries are an important part of the usage and work fine.
>
> The problem is that in order to generate a certain web page, we need
> to perform a great number of intermedia queries (like 14 o 15). This
> is part of the bussiness requirements and we cannot change it. So,
> even if each individual query is not that slow (from 1 to 3 seconds)
> the accumulation of them is quite fatal.
>
> My question is: what steps should be done to speed up the application?
>
> We've believe the application (sqls, etc...) is well designed. We
> cache everything that is cachable (query results, etc..). Our hardware
> is state-of-art Intel (dual processor, 1Gb ram, good hard disks).
>
> The size of the indexed data is about 20Gb.
>
> Apparently the bottlneck is IO (since CPU is not used 100%, and the
> network is not the problem). We have thought in adding more RAM, but
> since its a 32 bit server, the maximum would be 2Gb, and we are not
> sure whether this would make any difference.
>
> On the other hand we could buy more disks and try to spread the IO
> access evenly, but this is also a limited option.
>
> So, what can be done when the application is not fast enough??
>
> Thanks,
>
> -angel
You need to find your bottle neck (statspack is a good tool to help with
this) and then attach the problem that way. There is no way we can
reasonably tell you how to speed things up without a lot of detailed
information.
Jim
Received on Tue Sep 30 2003 - 04:40:24 CEST