• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Performance question

 
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi there,
can someone tell me the performance difference between
reading from an oracle db and reading from a flat file
now im reading from a oracle the data from a table this i proces and place it in a Vector
when i call this method and the vector is empty i fill it from the db..
my question when i place the processed Vector in a file
like write objectstream.writeObject(Vector) does this have a better performance.
the number of records read are about 100 to 1000 so that's not so mutch.
thanks in advance for your advise,
robert
 
author
Posts: 621
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It really depends on what you're doing with the data. Whether you're simply reading in everything from the file and using everything (as opposed to reading in an entire flat file and then only using 5% of the data) or whether you're constantly goig to the DB an finding indexed items, etc. There are so many factors relating to how efficient one way or another performs that, perhaps, the best way to know for your specific application (and DB setup - connection pooling, indexing, caching, etc.) is to write some test implementions using both methods and checking the speed for a connection, performance under heavy load (if that could be an issue), etc.. Hope this helps.
Sean
 
Do the next thing next. That’s a pretty good rule. Read the tiny ad, that’s a pretty good rule, too.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic