Yes ODBC connections is considerably slower i have found, it could also be the native connections class you may be using for ASP, but why why why. Bad mistake.
> Dear Members, > > For the last two years we have had a large software application written > in PHP 4.0.6 with a MySQL 3.23.56 database all running on a single box > with RedHat Linux 9.0. This has worked fantasticly and it is very > fast. > > For certain business reasons that I wont go into detail here, we had to > rewrite all the code from PHP to Microsoft ASP. The box that contained > the MySQL database on Linux remained as is. A second box was purchased > and runs the ASP code on Windows 2000 Server. The existing database on > the Linux box is called by an ODBC connection on the Windows machine. > > The problem is that now the software runs terribly slower. The reason > could not be that anything is wrong with the MySQL database since the > database on the Linux box was absolutely unchanged. I suspect that the > culprit is that PHP connects through a native MySQL driver, while in > our new way ASP connects through ODBC. > > Does anyone have any ideas about this ? > > David > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
