• Post Reply Bookmark Topic Watch Topic
  • New Topic

File Parsing and DB update

 
Ashwin B Philar
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everyone,
I have a small program that parses text files and update an access database, the number of records in the file do not exceed 2000. But the process is really slow. I parse each line, store the field values into an array, pass that array to another object which updates the database....
Is there a better and faster method to achieve this?
Please comment.
Regards,
Ashwin Philar
 
Blake Minghelli
Ranch Hand
Posts: 331
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you show any of your code that reads the file and parses the string into the arrays? Do you think it is the IO/parsing that's slow or the db updates?
Also, how are you doing the db updates? PreparedStatements can speed up execution time.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!