#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    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
    the script.

    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!

    yoshi
    datera@datera.com http://www.datera.com
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Aug 2000
    Location
    Indiana
    Posts
    614
    Rep Power
    16
    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).

IMN logo majestic logo threadwatch logo seochat tools logo