473,326 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 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 2160
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: David | last post by:
First, a question. Is there a way to keep VS.NET from red lining elements from third party controls with an error message that says 'the active schema does not support the element ****'? ...
1
by: Chris | last post by:
Does anyone have any documentation on compact privacy policy and asp.net session or http session cookies. I have a third party app that relies on a session cookie to maintain the state of my app...
0
by: ronnotel | last post by:
I have integrated APIs from a third party into my framework. The third party is essentially a .Net wrapper on top of an existing set of C++ classes and structs. I want to pass-around objects in...
6
by: Ben Finney | last post by:
Howdy all, I'm improving an existing application that's partly written using Python and the standard library. Many of the improvements I want to make can be done by using third-party free...
5
by: Daz | last post by:
Hi everyone, Sorry about the long thread name, I think that my problem is that I don't know how to word it, which is why I have been unsuccessful finding the information I require. I am...
4
by: m11533 | last post by:
I am developing a large application with Visual Studio .NET 2003 using C#. We recently added a new third party product with a native .NET library. I want to place this third party product's dll in...
4
by: Amar | last post by:
Hi All, I need to select data from a database table containing huge amount of data. Now I am storing data using one primary key and I am just using simple select statement, and this process...
5
by: rohitchawla | last post by:
How is it possible to read the third party cookies if u have a valid p3p policy set in place I have a server side application that sets the third party cookie and whenever the client visit any...
1
by: Chuck Chekuri | last post by:
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.