Darrell,
Friday, July 26, 2002, 10:43:32 PM, you wrote:
DAS> I am just getting started with MySQL and one of the first things I was
DAS> trying is converting one of my larger tables to MySQL to see what kind of
DAS> performance I would get from some standard queries that I run against it.
DAS> I built the table and created some indices that I thought would boost the
DAS> performance for my standard queries. I setup the ODBC on a Windows NT client
DAS> (the MySQL database is on Red Hat Linux 7.3 and the MySQL version is 3.23.51
DAS> that I downloaded on Wednesday.)
DAS> I ran the query below about 15 times successfully using a Visual Basic
DAS> program through the ODBC connection. The only queries taking place are
DAS> SELECT queries. There are no update queries of any kind being run, yet after
DAS> running the select query about 15 times I start getting the error message
DAS> below. Is this a standard problem that has a work around? I have dropped the
DAS> index and recreated it and I get the same behavior. It works fine for a few
DAS> queries and then the message appears.
DAS> Thanks for any help.
DAS> mysql> select * from Documents where type = 1 and (medplancd = ' '
DAS> or empno =' ');
DAS> ERROR 1034: Incorrect key file for table: 'Documents'. Try to repair it
Check your table and if it's corrupted, repair it:
http://www.mysql.com/doc/R/e/Repair.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
