471,067 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,067 software developers and data experts.

Third party indexing solutions

Hi,
We have a 3TB oracle db. 24x7 operation with data constantly coming in
to the DB. Users from all over the world use a web based applicaton to
query and work on the data.

Out transaction performance is quite good but our query performance
sucks. looking up by ids and some combinations of search critera
return ok but some never return. We indexed the db for a lot of
combinations and we materialized some views and that helped a little.
So far we haven't penalized our transaction throuput but if we
continue this path, our transaction performance will suffer.

We are looking into a third party indexing solutions. We are talking
to Omnidex.
Third party indexing solutions claim a dramatic performance
improvement for
people in our situations.

If any of you are using any third party indexing solutions on oracle,
please share your experiences.

Thank you very much,
Chuck Chekuri
DBA Manager
Vizional Technologies, Inc.
Santa Monica, CA - 90405
Jul 19 '05 #1
1 2064
"Chuck Chekuri" <cc******@vizional.com> wrote in message
news:ee*************************@posting.google.co m...
Hi,
We have a 3TB oracle db. 24x7 operation with data constantly coming in
to the DB. Users from all over the world use a web based applicaton to
query and work on the data.

Out transaction performance is quite good but our query performance
sucks. looking up by ids and some combinations of search critera
return ok but some never return. We indexed the db for a lot of
combinations and we materialized some views and that helped a little.
So far we haven't penalized our transaction throuput but if we
continue this path, our transaction performance will suffer.

We are looking into a third party indexing solutions. We are talking
to Omnidex.
Third party indexing solutions claim a dramatic performance
improvement for
people in our situations.

If any of you are using any third party indexing solutions on oracle,
please share your experiences.

Thank you very much,
Chuck Chekuri
DBA Manager
Vizional Technologies, Inc.
Santa Monica, CA - 90405


I'm going to ask a possibly stupid question, but what are your bottlenecks?
What leads you to believe that a 3rd party indexing solution will solve your
problem? (I don't know that it will not, but there isn't a lot of data to go
on in the posting.)
Jim
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Chris | last post: by
reply views Thread by ronnotel | last post: by
6 posts views Thread by Ben Finney | last post: by
1 post views Thread by Chuck Chekuri | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.