Thanks for your input Scott. My tables currently do not have indexes. Would
adding indexes to the tables fix the problem. Or do I need to drop the
tables and create them again with indexes. I tried to use the check command:
CHECK TABLE test_table FAST QUICK;
but it returned this error.
ERROR 1064: You have an error in your SQL syntax near 'CHECK TABLE custinfo
FAST QUICK' at line 1.
This table needs to be repaired soon b/c of the volume of users that will be
coming in. I appreciate your help.
Thanks!
Dave Young
Applications Engineer
www.gluepoint.com
"We make billing easy."
----- Original Message -----
From: Scott Baker <[EMAIL PROTECTED]>
To: David Young <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, January 15, 2001 9:01 AM
Subject: Re: query not responding
> Sounds to me like your indexes got corrupted. You can try fixing them
with
> the table fixer thing. But since you have such small data, just drop them
> all, and recreate them.
>
> At 01:09 AM 1/14/2001 -0800, David Young wrote:
> >Ok, here's the scoop. After 3 days of research, noone has been able to
> >give me an answer ...hopefully someone here can..yay! Anyway, I've got
> >several tables all with 350+ records. The db itself has about 15 tables.
> >When I run this query:
> >
> >"select field1 from table1;" it just sits there.
> >
> >When I run this query:
> >
> >"select field1 from table1 where field1 between '1' and '37';" it will
> >display 37 records as requested.
> >
> >Now if I run the second query ..."select..between '1' and '38';" it just
> >sits there....I've been running queries on this table for about 10
months.
> >It's only a few days ago it decided not to respond to me, forcing me to
> >take down a tool that was running off the table.
> >
> >Any ideas or suggestions as to a query I've run hundreds of times decided
> >to just sit there?
> >
> >Any help would be great!
> >
> >Thanks!
> >Dave Young
> >Applications Engineer
> ><http://www.gluepoint.com>www.gluepoint.com
> >"We make billing easy."
>
>
> -------------------------------------
> Scott Baker - Webster Internet - Network Technician
> 503.266.8253 - [EMAIL PROTECTED]
>
> "Always bear in mind that your own resolution to success is more important
> than any other one thing." - Abraham Lincoln
>
>
---------------------------------------------------------------------
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
