-----Original Message----- From: Miguel Pereira [mailto:migu...@hotpop.com] Sent: Saturday, January 19, 2002 2:54 PM To: Win32 mySQL Subject: ASP + myODBC + mySQL4.0.1

Hi, I've been experiencing very bad performance issues running a simple query retrieving information from a single table. The table so far has the following structure|:

| ID | ITEM | COUNTRY | MINUTES1 | MINUTES2 | MINUTES3 | RATEpMIN |

Containing at least 3,000 records. The DATA TYPE for each field is as follows ID MEDIUMINT ITEM VARCHAR(35) COUNTRY VARCHAR(35) MINUTES1 INT MINUTES2 INT MINUTES3 INT RATEpMIN FLOAT

RUNNING THIS QUERY: SELECT item,country,min1,min2,min3 FROM tbl_name WHERE item = prod_name ORDER BY country DESC;

UNDER THE mySQL CLIENT TAKES APROX. 0.61 SECONDS, WHILE DOING IT TRHOUGH myODBC AND A SIMPLE .asp PAGE TAKES NEARLY 6 seconds. I WOULDN'T BE CONCERNED IF THIS WAS THE PERFORMANCE OVER A TCP/IP LAN....OR INTERNET. BUT IM RUNNING IT LOCALY FOR TESTING PURPOSES. IT IS NOT A HIGH-END SYSTEM, BUT IT COVERS PRETTY MUCH MEMORY AND SPEED REQUISITES.

P2 450MHz 288 Mb 100MHz 7,500 rmp HD (IDE) WINDOWS 98se

DOES ANYONE HAS ANY IDE??, IS IT POSSIBLE THAT RETRIEVEING 250 RECORDS OUT OF THE DATABASE IS NOT THE PROBLEM BUT A PROBLEM OF THE .asp CODING?, COULD BE THE WEB SERVER APPLICATION??