Hello, JOE. You wrote 22 марта 2002 г., 15:06:36:
1.indexes exist. 2.query like "select count(some_table.itemID) from some_table where keywords like '%begin' or like 'end%'". 3.table ~70M. MJA> The MySQL book by DuBois (published by New Riders) will tell you everything MJA> you need to know about MySQL. Also, it sounds like you don't have any MJA> indexes built for your table if a "very simple query" is taking a long time. MJA> Indexes will decrease your time to almost nothing, unless your query is not MJA> as simple as you indicate; faulty query construction can devastate a query's MJA> response time. MJA> -----Original Message----- MJA> From: Babichev Dmitry [mailto:[EMAIL PROTECTED]] MJA> Sent: Friday, March 22, 2002 6:05 AM MJA> To: [EMAIL PROTECTED] MJA> Subject: MySQL MJA> Hello, beginners. MJA> Sorry for offtopic. MJA> Could you help me. MJA> How i can decrease time demand fetching for a very simple query? (in my case MJA> i have MJA> trouble because table is very big) MJA> Where I can read about this? MJA> fanx. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
