• 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 all forums
this forum made possible by our volunteer staff, including ...
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Performance question  RSS feed

Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • 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,
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • 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.
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!