RE: MySQL 4.18 Performance Question

2005-11-14 Thread Logan, David (SST - Adelaide)
Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Shahryar G. Hashemi [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 November 2005 8:52 AM To: mysql@lists.mysql.com Subject: MySQL 4.18 Performance

MySQL 4.18 Performance Question

2005-11-14 Thread Shahryar G. Hashemi
Hello, We are running a MySQL 4.18 database as a read-only snapshot of an internal Sybase database. We have seen an increase in core tables where now we have several million records of data in the MySQL tables. Suddenly the SELECT queries we ran before which took few seconds are now taking m