Intermedia queries slow any ideas?

From: Kev.- <java2e_at_yahoo.com>
Date: Tue, 10 Apr 2001 10:21:57 GMT
Message-ID: <3ad2deb4.174556238@ns1.nothingbutnet.net>

Hello I am trying to user Intermedia but it is extremely slow.

For example I have about 40,000 records that are in a CLOB column. When I do a search with the contains it takes for ever to return the results. How can I speed this up? I have tried updating statistics, etc... I cannot seem to make it speed up.

It I choose say the word plsql it can take almost a minute +. I dont understand because if I go to a search liek groups.google.com it is like it is running on my local machine. How can I obtain that speed?

Oracle ver 8.1.7
NT Server 4 service pack 5
756 megs ram.

Anyone? Received on Tue Apr 10 2001 - 05:21:57 CDT