SQL Query slow with 'Select' ....
| From: | Scott Fletcher | Date: | Wed, 09 Jul 2003 20:29:42 +0000 |
| Subject: | SQL Query slow with 'Select' .... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-154627@lists.php.net to get a copy of this message | ||
I noticed that database are very quick with the SQL Query string such as
Insert, Delete and Update. But with Select, it become very slow. I noticed
that I can do the INT() or DOUBLE() for one of the field when using Select
and it become very quick. But I am unable to make it work for CHAR() or
varchar for MS-SQL. Does anyone know?
Thanks...