Re: Resource Sharing or Resource Scheduling ??

hi again well Yes, i m gonna do that, but the question remains there wht if i do resource sharing means that if i want to block the connection sharing like what is being done in Java or other applications called connection pooling, so how can it be done in PHP, just like java uses sleep() function , so is there any technique present in PHP???? Miha Nedok <mike@voyager.unix-systems.net> wrote: 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 > 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 --------------------------------- Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software