• Post Reply Bookmark Topic Watch Topic
  • New Topic

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,
robert
 
author
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.
Sean
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!