Justtechjobs.com Find a programming school near you






Online Campus Both


php4-beta | 200004

RE: [PHP4BETA] A question about PHP and Mysql From: Chris Adams (chris <email protected>)
Date: 04/06/00

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. 

-- 
PHP 4.0 Beta Mailing List <http://www.php.net/version4/>
To unsubscribe, e-mail: php4beta-unsubscribe <email protected>
For additional commands, e-mail: php4beta-help <email protected>
To contact the list administrators, e-mail: php4beta-admin <email protected>