Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC and PERL

 
Arjunkumar Shastry
Ranch Hand
Posts: 986
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We have two database tables.The PERL script is being run from SQL job.This PERL script reads the records from one table and inserts or modifies the records in second table.This is being done by using Left JOIN between two.
Running time for this script exceeds 8 hours.Records are approximately more than 1,50,000.We are thinking of reducing this time.
If we write Java program and implment the same logic,is there any chance that this time will get reduced?
Database:SQL Server 2000
PERL script running on same machine as database.
Both tables are in same database.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Arjun,
As often happens in computers, it depends.

Before making any changes, you need to gather some statistics. In particular, find out how much time is being spent in the database, network and program. You can do this through database logs and adding application logging.

If it is the database, you need to tune the SQL or add indexes. If it is the network, you can investigate whether any less data can be sent/retrieved. It is the PERL program itself, a conversion to Java could help (or more likely a tuning of the PERL program.)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic