Re: Problem of Speed and db update

David Tod Sigafoos wrote: > OS: win2k > Server: httpd > phpver: 4.0.2 > DB: Mysql (fresh download) > > The code below I got from a tutorial at WebMonkey. > > The process of bringing up the list of names on first pass is very > fast. The process of bringing up the edit form is very fast at > displaying info from server. > > The problem comes in where the update happens. This is very very > slow. Now I can't see that this would be a php problem (i have posted > similar question on httpd news list) but my question is there anything > in php which could cause a 20-30 second delay? > > I have 'inserted' 5000 records from command line into mysql and all > 5000 records only took 5 seconds. So it doesn't "look" like a server > problem. Could it be a very *bad* odbc driver? 1) The built-in MySQL functions have nothing to do with ODBC drivers. PHP4 has MySQL connectivity compiled in, so you don't have to worry about ODBC setups here. 2) You might want to try installing phpMyAdmin (www.phpwizard.com) - a set of php scripts for connecting to/updating/administering MySQL databases from within your web server. If the phpMyAdmin scripts show the same difficulties then it's not your script :) What web server is "httpd"??? (never heard of it before) Perhaps this is an issue with the web server software itself? -- Andy Hoffman Web Developer Bristol-Myers Squibb email: andy.hoffman@bms.com