Re: RAM based database management

Hi Femi,

Did you create an index on the table in question? If so is the most important column named in the where clause of your query the first column in the index? If the answer to these two questions is yes and you are running with Oracle 7.1 or later and using the Cost Based Optimizer have you analyzed the table?

If you have done these things it is time to start looking at the general environment you have set up on your system. Oracle is a highly tunable RDBMS and based on a two orders of magnitude difference between C++ and Oracle it sounds like your Oracle configuration and your query need a tune-up.

Regards

Jerry

Femi Aderounmu wrote:
>

        (snip)

> A simple test query I developed for a table of 20,000 rows runs 100
> times slower on Oracle than when I use C++ with the data loaded in a
> disk file. I came to the conclusion that the Oracle operation is slower
> because of the Rollback operations and that is why I decided to load the
> Oracle data into RAM.
>
> When I say the Rollback segment blows up I mean it keeps getting larger
> and larger endlessly and I've had to delete it at intervals. I would
> expect it to purge itself at intervals but that does not seem to be
> happening here.
>
> --
> Femi Aderounmu
> New Jersey
> --
 

-- 
Jerry Gitomer		Since I know how to spell DBA I became one. 
jgitomer_at_p3.net