Re: connect slowly

From: FaheemRao <faheemrao_at_yahoo.com>
Date: 20 Oct 2001 01:50:05 -0700
Message-ID: <43b58913.0110200050.4003df6b@posting.google.com>

When you say accessing a table,How do you exactly access the table, if you are having joins in SQL queries , or may be you are using a corelated query, which are relatively slow. try to put indexes on you table.

Faheem Rao

"sang" <sang_at_technical-e.co.jp> wrote in message news:<9qqj2o$hqb$1_at_nn-os104.ocn.ad.jp>...
> Hi, alls
>
> In my Database, I use OCI to develop my soft to connect to ORACLE 8.0.5.
> DB Server is Inter 586 128M RAM.
> I have five or six process running in different computers in one LAN.
>
> Some day i found that it is very slow to access to DB.
> It is very strange to me that some tables are very fast, while some tables
> are very slowly.
> The slowly tables are very small or emty.
>
> What i will do?
>
> Thanks in advance.
>
> webjb
Received on Sat Oct 20 2001 - 03:50:05 CDT