retrieving data fastly using vb and oracle


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: retrieving data fastly using vb and oracle

  1. #1
    Om Prakash Guest

    retrieving data fastly using vb and oracle


    hi,
    can any one suggest plz some methods to retrieve data fastly using vb as
    a front end and oracle as the back end. what type of tunnings has to be done
    to increast the access rate.i want it badly.hope u will respond quickly.
    thanks sir.


  2. #2
    Chris Hylton Guest

    Re: retrieving data fastly using vb and oracle


    Depends on what you are trying to do...more detail on your specific problem
    might help someone give you better advice.

    At a high-level, speed depends on a number of things including how you need/intend
    to use and navigate the data on the VB end.

    ADO will be pretty fast pulling the databack into a recordset, and I have
    benchmarked using the OLEDB ODBC driver w/ a DSN/DSN-less connection VS.
    using the Oracle OLEDB provider from both MS and Oracle. The latter is somewhat
    faster (so eliminating ODBC from the equation would desirable in my opinion).

    Depending on your recordset navigation needs, if you only need to loop through
    the data once and don't need to move backward through the data at any point,
    using a forward only recordset will improve client performance.

    If you don't need to update the data directly (i.e. any updates will go back
    through SQL statements or Stored Procs), then a read-only recordset might
    also give you a slight performance edge.

    These are only some 'ideas' for things to tweak to increase performance.

    If you really want to use OO4O from VB, I definitely suggest you check the
    performance and at the very least, keep ALL of your code in OO4O objects...when
    you start trying to convert OO4O resultsets (or whatever they call them),
    the looping processes required to move that data to arrays or other VB objects
    will be VERY time consuming, it's just extra code that would be unncessary
    if you design yourj OO4O object correctly to handle everything you need.

    The fastest code would obviously (in almost all cases) would be to handle
    the data on the server (if you have a server that can handle it and that
    isn't going to be hit by hundreds or thousands of users at once) through
    cursors and/or SQL statements in Oracle. Just return minimal data and results
    of processes to VB for user status messages.

    Chris

    "Om Prakash" <omprakash@sugunapoultry.net> wrote:
    >
    >hi,
    >can any one suggest plz some methods to retrieve data fastly using vb as
    >a front end and oracle as the back end. what type of tunnings has to be

    done
    >to increast the access rate.i want it badly.hope u will respond quickly.
    >thanks sir.
    >



  3. #3
    Chris Hylton Guest

    Re: retrieving data fastly using vb and oracle


    BTW...I haven't benchmarked any of this lately (in the last few releases of
    ADO...but if you have tons of data to process on the client...you might try
    something that I don't recommend. That would be to attempt an ODBC Direct
    call to the data via DAO. DAO is on it's way out, old technology, Microsoft
    doesn't support it anymore. I think folks will continue to code in it for
    some time to come, but I don't know that I'd do much new development in it,
    unless the project absolutely called for it.

    Anyway...DAO w/ ODBC Direct used to product quite good results when compared
    to RDO and early releases of ADO...much faster in processing data on the
    client...worth a quick look, but I'd stick w/ ADO unless you really have
    SERIOUS performance issues with your solution...

    Chris

    "Chris Hylton" <cchylton@hotmail.com> wrote:
    >
    >Depends on what you are trying to do...more detail on your specific problem
    >might help someone give you better advice.
    >
    >At a high-level, speed depends on a number of things including how you need/intend
    >to use and navigate the data on the VB end.
    >
    >ADO will be pretty fast pulling the databack into a recordset, and I have
    >benchmarked using the OLEDB ODBC driver w/ a DSN/DSN-less connection VS.
    >using the Oracle OLEDB provider from both MS and Oracle. The latter is

    somewhat
    >faster (so eliminating ODBC from the equation would desirable in my opinion).
    >
    >Depending on your recordset navigation needs, if you only need to loop through
    >the data once and don't need to move backward through the data at any point,
    >using a forward only recordset will improve client performance.
    >
    >If you don't need to update the data directly (i.e. any updates will go

    back
    >through SQL statements or Stored Procs), then a read-only recordset might
    >also give you a slight performance edge.
    >
    >These are only some 'ideas' for things to tweak to increase performance.
    >
    >If you really want to use OO4O from VB, I definitely suggest you check the
    >performance and at the very least, keep ALL of your code in OO4O objects...when
    >you start trying to convert OO4O resultsets (or whatever they call them),
    >the looping processes required to move that data to arrays or other VB objects
    >will be VERY time consuming, it's just extra code that would be unncessary
    >if you design yourj OO4O object correctly to handle everything you need.
    >
    >The fastest code would obviously (in almost all cases) would be to handle
    >the data on the server (if you have a server that can handle it and that
    >isn't going to be hit by hundreds or thousands of users at once) through
    >cursors and/or SQL statements in Oracle. Just return minimal data and results
    >of processes to VB for user status messages.
    >
    >Chris
    >
    >"Om Prakash" <omprakash@sugunapoultry.net> wrote:
    >>
    >>hi,
    >>can any one suggest plz some methods to retrieve data fastly using vb as
    >>a front end and oracle as the back end. what type of tunnings has to be

    >done
    >>to increast the access rate.i want it badly.hope u will respond quickly.
    >>thanks sir.
    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center