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