Re: updating an online database

[Irv Kalb]

I don't know if the problem is in your net routines or at the server, 
but I have have a different approach to net routines.  I have a whole 
chapter in my on line book on building a net manager that would 
handle many net calls.  Check it out at:

http://www.furrypants.com/loope/

Chapter 14 goes into detail about this.  I have used this net manager 
to do exactly what you are describing - sending postNetText commands 
to a CGI script (PHP) that talks to a database (mySQL)

I would guess hat your current approach locks out user activity while 
all the messages are being sent.  My net manager allows all 
interactivity to continue while the messages and net checking are 
handled in the background.

Irv

At 12:23 PM +0000 2/5/04, Lee Blinco wrote:
Hi list,
i'm updating an online mysql database with 3 fields, in 982 records and
basically its unreliable it doesn't manage top do all the updates or even a
consistent numberit usually falls about 100 short.
--

Multimedia Wrangler.

[To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi  To post messages to the list, email [EMAIL PROTECTED]  (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo.  Thanks!]