MySQL Forums
Forum List  »  Perl

How to reuse DSN using session or cookies ?
Posted by: rais shaikh
Date: August 06, 2008 04:30AM

Hello Frndz,
I have written a perl program that continuously fetching data from remote
mysql server (snort alert) into local mysql database.
1. perl program will create a child process and then use DBI interface to
create data source (DSN) to connect the Mysql server.
2. DSN then collect data from mysql server and fetch data into local database
using while loop and then again recreate the DSN for continuous process .

Problem : I want to reuse the DSN instead of recreate bcoz after continuous 5 or 7 hour of process the data in local database are lagging behind from server databases which has to be synchronize(i.e if server database timestamp is 3:00 P.M then local database timestamp is 1:00 P.M there are delay in fetch the data ).

Is there solution for this or we can use session for DSN ?

NOTE : This is note a Web server application , just database transfer.

Options: ReplyQuote


Subject
Written By
Posted
How to reuse DSN using session or cookies ?
August 06, 2008 04:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.