long wait for user

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
BigJonMX
Forum Newbie
Posts: 15
Joined: Sun Nov 20, 2005 11:28 am
Location: CardboardBox, WindyCity

long wait for user

Post by BigJonMX »

Hi,
i have a button in my app that triggers a long and complicated sql process: a table of records is altered/updated according to pages of criteria. The sql has been optimised numerous times, but it still takes minutes to complete.

Is there a way i can have my sql running 'in the background' so that the user is returned to index, or some other page, and can continue using the app, and when the complicated-process is finished, maybe a popup appears, or a message appears saying its done?

Thanks for any tips, BJ
User avatar
markusn00b
Forum Contributor
Posts: 298
Joined: Sat Oct 20, 2007 2:16 pm
Location: York, England

Re: long wait for user

Post by markusn00b »

I guess you could use ajax.. but if the user anvigated away from the page they wouldn't be alerted as to it's completion.
Post Reply