Splitting the SQl Statements

Hi all,

I have to synchronize two different databases in my application.

Since this operation has many queries to execute, it will take lot time to complete. Once the operation is complete i have to redirect my page to some other page. The application will time out before redirecting(for some browsers like firefox and safari) if the number of users is more in the database from which i want synchronize.

what is the solution for this.

Is there any technique to execute the queries step by step(for eq: 100 users per time)

Thanks in Advance

Phoenix

[593 byte] By [Phoenioxa] at [2007-11-27 6:32:56]