Re: Resource Sharing or Resource Scheduling ??

An alternative could be switching to a SQL server ( MS SQL ) or the free MySQL (which performes on unix-like systems better ). I avoid using Access databases because of problems like you described. -Mike On Wed, 6 Aug 2003, Raheel Hussain wrote: > Date: Wed, 6 Aug 2003 23:16:58 -0700 (PDT) > From: Raheel Hussain <raheelphp@yahoo.com> > To: php-windows@lists.php.net > Subject: [PHP-WIN] Resource Sharing or Resource Scheduling ?? > > hi all, > > i've made an application , which serves more than 35 cuncurrent users at a time, > now wht i m doing on the page where the data is being submitted is : > > run a loop which iterates through all the submitted data of $_REQUEST > and i make a query and update that to the Access Database, on every rep of that loop. > > the loop iterates five times, now .............. > > if 35 users submit at the same time, > the loop will run five time each for each of the user i.e 35 x 5. > > here my application crashes and every person ( user ) is redirected to the login page, and all > the data is lost in-between the application run. > > note : no error is raised by the script or server. > > any comments, on how can i do resource sharing or connection sharing etc. to avoid that???? > > > regards > raheel > > > > > > > > > > > > --------------------------------- > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software