Hello Mike, Am Dienstag, 5. Oktober 2004 um 15:51 schriebst du:
> FYI > select * from dbmail_messageblks; > (5,075 InnoDB 48.4 MB ) > 5075 rows in set (0.54 sec) > mysql> > SunOS5 MySQL4.0.21Max That is what it should be, yes. To answer all the other mails now: Yes, it is a very slow box, PII with 300 MHz, 256MB RAM, W2K OS, the harddisk is very old & slow too, the HD Tach test says average 10 MB which is not too bad. I figured that running the same query on all rows instead of fetching only the first 100 last just few second longer, and when I execute it from a remote host it last only 20 seconds which is still slow, but I can live with that as long as I know that the box is simply too slow to act as a database server at all. I'll install a faster harddisk now, maybe that helps. BTW I used the pgAdmin III query tool, which is included in the setup, to execute the select statement, nice tool. Gerrit -- =^..^=