Re: Mysql query it too slow in big table

2001-12-18 Thread xutian
- Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "xutian" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 12:27 PM Subject: Re: Mysql query it too slow in big table > In the last episode (Dec 1

Mysql query it too slow in big table

2001-12-18 Thread xutian
###table struct of COLL_DATA mysql> desc COLL_DATA; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | TASK_ID | bigint(20) | YES | | NULL | | | E_TYPE_ID | int(11) | YES