Page 1 of 1

long wait for user

Posted: Sun Feb 17, 2008 4:27 am
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

Re: long wait for user

Posted: Sun Feb 17, 2008 9:32 am
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.