RE: [PHP4BETA] A question about PHP and Mysql

On Thu, 6 Apr 2000 13:05:45 -0700 (PDT), Alex zhang wrote: >I have tried it and checked it with Explain(looks >right). Same result. >It acturally occurs when you have too much entries >return in big tables >pls try! >Anyway, thanks What version of MySQL are you using & have you used any configuration. I made a quick test with Mysql 3.22.34 for NT on my desktop with the following config options: set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 Here's the simple table I used: +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | ID | int(11) | | PRI | 0 | | +-------+---------+------+-----+---------+-------+ mysql> select count(*) from Count_Test; +----------+ | count(*) | +----------+ | 3639820 | +----------+ 1 row in set (0.00 sec) Obviously, this doesn't look like some intrinsic problem with MySQL; I'd check the details of your configuration.