>Description: Queries to a table with BLOBs are very slow. I query select id,name,lator,lonor,latpp,lonpp,width,height from segments order by name The table is defined as: create table segments ( id int not null auto_increment primary key, name char(100) unique, scale int not null, dpi int not null, width int not null, height int not null, lator double, lonor double, map mediumblob, latpp double, lonpp double, index(id), index(name)); >How-To-Repeat: try the select statement >Fix: ? >Submitter-Id: <submitter ID> >Originator: Andrej Andrejko <[EMAIL PROTECTED]> >Organization: >MySQL support: none >Synopsis: slow queries with BLOBS >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.21-beta (Source distribution) >Server: /usr/bin/mysqladmin Ver 8.7 Distrib 3.23.21-beta, for redhat-linux-gnu on >i386 TCX Datakonsult AB, by Monty Server version 3.23.21-beta-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 2 days 9 hours 37 min 8 sec Threads: 2 Questions: 5700 Slow queries: 98 Opens: 22 Flush tables: 1 Open tables: 8 Queries per second avg: 0.027 >Environment: System: Linux andrej 2.2.16-17smp #1 SMP Wed Jul 26 15:53:36 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 20000724 (experimental) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 14 Aug 5 2000 /lib/libc.so.6 -> libc-2.1.91.so -rwxr-xr-x 1 root root 4615653 Jul 25 2000 /lib/libc-2.1.91.so -rw-r--r-- 1 root root 22294328 Jul 25 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jul 25 2000 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql --------------------------------------------------------------------- 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