Hello list I've just installed mysql-3.23.33 with db-3.2.9a (linux on a ppc) and still have dog slow bdb tables with data errors. How fast are bdb tables really, for those where they work? Doing 3 queries/sec is not a real option for me. Note that I had to change the makefile in db-3.2.9a/build_unix or it would not have installed: from install: all # modified by MySQL configure install_include install_lib install_utilities install_docs to install: install_include install_lib install_utilities install_docs Christian. Tests: ----- mysql> create table bdbtest4 (a int not null primary key, b text) type=bdb; Query OK, 0 rows affected (4.03 sec) mysql> insert into bdbtest4 values(0,"Miau"); Query OK, 1 row affected (1.61 sec) mysql> insert into bdbtest4 values(1,"Cat"); Query OK, 1 row affected (0.33 sec) mysql> select * from bdbtest4; +---+------+ | a | b | +---+------+ | 0 | Miau | | 1 | Cat | +---+------+ 2 rows in set (0.33 sec) mysql> select * from bdbtest4 where a=1; +---+------+ | a | b | +---+------+ | 1 | à | +---+------+ 1 row in set (0.14 sec) mysql> select * from bdbtest4 where a=0; +---+------+ | a | b | +---+------+ | 0 | à | +---+------+ 1 row in set (0.14 sec) mysql> status -------------- mysql Ver 11.12 Distrib 3.23.33, for unknown-linux-gnu (powerpc) Connection id: 1 Current database: test Current user: chris@localhost Current pager: stdout Using outfile: '' Server version: 3.23.33 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: german1 Server characterset: german1 UNIX socket: /tmp/mysql.sock Uptime: 8 min 20 sec Threads: 1 Questions: 33 Slow queries: 0 Opens: 26 Flush tables: 1 Open tables: 18 Queries per second avg: 0.066 -------------- mysql> System: ------ linuxppc (powermac 9600/300mhz), kernel 2.2.17 , glibc 2.1.3, gcc-2.95.3 Configure: --------- ./configure --with-charset=german1 --with-extra-charsets=latin1 --with-berkeley-db --localstatedir=/home/mysql -- Web Office Christian Jaeger Corporate Communications, ETH Zentrum CH-8092 Zurich office: HG J43 e-mail: [EMAIL PROTECTED] phone: +41 (0)1 63 2 5780 [EMAIL PROTECTED] home: +41 (0)1 273 65 46 fax: +41 (0)1 63 2 3525 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php