August 8th, 2000, 11:03 PM
Hello. I am posting this message to multiple groups...
I have a very large MySQL table (over 1,000,000 rows, 7 columns) running with my site,
and I need to write a script to bring the called data to the screen in HTML
as quickly as possible.
I have been testing with CGI, learning PHP, and now considering ASP. My current script
(in PHP) takes 30 sec. to load, the CGI (not mod_perl) takes a couple seconds longer.
I don't know what takes the largest proportion of the time, getting the data or running
Is there any advantages in speed between CGI, mod_perl, PHP, and ASP?
I am attempting to mod_perl my CGI, but I am using a remote server... Thanks!
August 9th, 2000, 01:49 AM
Something of that size is slowed down by the SQL server. That's really the only important part. Maybe you should consider upgrading to a Microsoft SQL server and running ASP's. (This is the solution for a huge e commerce site).