Visokio website     Downloads     Video tutorials     KnowledgeBase  
Database import: Oracle Array Size - Visokio Forums
Database import: Oracle Array Size
  •     bgrovens February 21, 2012 2:30PM
    Hi Visokio - We have created a series of views to load data into Omniscope. I have noticed that increasing the Oracle Array size manually (when running the view in an SQL program such as Rapid SQL) increases the speed in which the view loads. Is there a way to overide the default array size that Omniscope pulls? We are currently doing performance testing with some our our data that takes a while to compile and this was one of the options that has been discussed. Let me know if a call would be better suited for this?

    Thanks, Brian
  • 2 Comments
  •     steve February 21, 2012 3:23PM
    Brian, do you mean JDBC row prefetch size? Can you describe where/how you have configured this 'array size'?
  •     bgrovens May 22, 2012 4:29PM
    Steve,

    You can close this discussion. We found that really digging in and spending time on the Oracle Indexes fixed the issue.

    Thanks,
    Brian
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership