Re: Insert query

2003-05-31 Thread Ulterior
sow what would you suggest, Jerry? ( I need a very FAST search on this table's filename field) Ulterior > Don't use varchar unless you absolutely have to, that should help. > > Jerry > > - Original Message - > From: "Ulterior" <[EMAIL PRO

Re: Insert query

2003-05-31 Thread Ulterior
So what would be an alternative to varchar? text? but then how mysql will index such table? text is a blob record. Ulterior - Original Message - From: "Jerry" <[EMAIL PROTECTED]> To: "Ulterior" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Satu

Insert query

2003-05-31 Thread Ulterior
hes 99% of my processor timing. I am using native mysql C API mysql_query() func for inserting data. Is there any way to speedup insert querys to this table? ( I am planning to have at least 2-5 million entries in this table ) Ulterior -- MySQL General Mailing List For list archives: ht