dirksamson
Posts: 32
|
| Posted: 10/22/2004, 12:40 AM |
|
I'm developping on my own machine, using an ODBC connection to another machine on my (local) netwerk which is a MySQL server. MySQL seems to run just fine and (for instance) navicat and phpMyAdmin connect to it just fine, and fast.
My codecharge project (residing on my local harddisk, viewed with IIS on my own computer) is extremely slow, loading a page often takes more than 30 seconds. Placing the same project on the 'live' server, wich is an apache/mysql server results in a very fast website (loading << 1sec; my project isn't extremely large or database-intensive).
It looks as if the (persistent) connection from my own computer to the mysql server is very slow for some reason, but only from within codecharge. Any experiences?
_________________
Dirk |
 |
 |
klw
|
| Posted: 10/22/2004, 10:09 AM |
|
Could be an IIS misconfiguration with PHP.
Have you tried uninstalling and reinstalling PHP on your local machine?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/22/2004, 12:22 PM |
|
It could also be a database indexing issue.
Maybe take a look at:
http://www.karakas-online.de/EN-Book/proceed-when-mysql-slow.html
http://www.google.com/search?hl=en&lr=&q=mysql+slow+php
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
E.
|
| Posted: 10/28/2004, 10:17 PM |
|
Check the name of the computer on which mysql runs.
You should use the full name of the host.
For example:
if the full name is remotehost.blabla.net, and the connection is made to remotehost (without blabla.net), it tries to retreive the name by the dns-suffix (which could contain .blabla.net). This may slow down the performance.
Good luck.
E.
|
|
|
|
dirksamson
Posts: 32
|
| Posted: 10/29/2004, 4:52 AM |
|
peterr: Placing website and database server on the same machine results in a very responsive website; so mysql itself probably isn't the problem
E.: Both computers are on my local network (with my own dns server). I'm now using the IP-address of the mysql machine. Unfortunately, that doesn't solve the problem either...
_________________
Dirk |
|
|
|
peterr
Posts: 5971
|
| Posted: 10/29/2004, 12:24 PM |
|
OK, it was just an idea. Sorry if I couldn't help. Hopefully someone else can.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
