JDBC is so generic (mostly) that it is tough to break the sound barrier with something so straight forward as extracting data. However, you might think about these:
1. Query optimization: If you can get the queries to run faster you will improve performance, but if you have a lot of datam you will still be hit by retrieve time which will be independent of how optimized your SQL is. 2. Oracle has several PL/SQL based optimizations and you may be able to retrieve arrays of records. This is quite fast if you can do it. //Nicholas --- sudhendra seshachala <[EMAIL PROTECTED]> wrote: > Hi > currently working on some extraction of data from > various databases like oracle, DB2, sybase etc., > Apart from using the native tools provided by > vendor, > is there something we can do using JDBC. > We are using JBoss 3.0.2 > what is the best way to do high speed extraction > using > JDBC. I do not want to use pre-fetch buffer. It > leads > to iterations of resuletsets. > Just need a better mechanism.... any > suggestions/clue > appreciated. > > thanks > sudhi > > > ===== > God Bless America > > __________________________________________________ > Do you Yahoo!? > New DSL Internet Access from SBC & Yahoo! > http://sbc.yahoo.com > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user ===== Nicholas Whitehead Home: (973) 377 9335 Cell: (201) 615 2716 Work: (212) 622 5639 [EMAIL PROTECTED] __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
