[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[cobalt-users] Off Topic Question asp vs php
- Subject: [cobalt-users] Off Topic Question asp vs php
- From: "Jamie Rossi" <jamie.rossi@xxxxxxxxxxxx>
- Date: Wed Nov 27 12:21:28 2002
- List-id: Mailing list for users to share thoughts on Sun Cobalt products. <cobalt-users.list.cobalt.com>
Hi
I have a site on a Cobalt Raq4 that has a mysql backend database. This
database has roughly 20,000 records. The RAQ4 has 768MB of memory
At present the site uses ASP, and what I find is a page that queries the
database in ASP can take 30 seconds to return the records.
I recreated the functionality and the sql query in php and the response
time is down from 30 seconds on a 512KB link to around 4 seconds.
What is the view on the best way to connect to a mysql database on a
RAQ4? The asp site uses ODBC currently. Obviously something is wrong.
Kind Regards
Jamie Rossi
PS. The site can be found at http://www.destinationsuk.com if anyone
wants to take a look. Try selecting Surrey, then Go_eat, then all
records to see what I mean.