Dear Members,That's right.
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
ODBC is an additional abstraction layer between your code and MySQL, whereas the MySQL driver that mod_php uses is optimised for use explicitely between MySQL and PHP. There is a lot of extra baggage that you're dragging around with ODBC.
Also, I assume that the app originally ran on the one box, ie apache with mod_php was on the same box as MySQL. Putting the web server on a different box and running queries across a network is obviously going to slow things down.
I would also expect that IIS / ASP is slower than Apache / PHP, no matter what DB drivers you're using.
So yes, your app should run considerably slower.
If you post some details about what you're doing, maybe someone can give you some pointers as to how to optimise things. Bad luck about the decision from above :-(
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]