Re: connect slowly

No, i simply run this sql:
Select * from email_new;

The table email_new is the templete table, one process adds data to it, and another process gets data from this table and deletes it after doing something .

You know the table which accesses fast was built early, after my db become to big, i create the new tables which are slowly to access.

So, i think the reason is not the index.

webjb

"FaheemRao" <faheemrao_at_yahoo.com> wrote in message news:43b58913.0110200050.4003df6b_at_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 - 08:09:56 CDT