Re: Pattern Match on 3.23

On Tue, 31 Dec 2002, Frank Peavy wrote: > I asked the pattern match question, because I am using a hosting service > that hosts MySQL 3.23. Since I have a need to search on terms less than 3 > characters long and I can not re-compile, I was looking for another > solution. I thought that I might be

Re: Pattern Match on 3.23

Thanks Qunfeng, Hope you have a Happy New Year.! At 11:17 AM 12/31/02 -0800, Qunfeng Dong wrote: We are running on linux redhat 7.3, RAM 4G, I am using my.huge-cnf. 1.2Ghz dual CPUs PIII. The mySQL database resides on SCSI disk. We do pattern search on varchar or text fields of a table with

Re: Pattern Match on 3.23

We are running on linux redhat 7.3, RAM 4G, I am using my.huge-cnf. 1.2Ghz dual CPUs PIII. The mySQL database resides on SCSI disk. We do pattern search on varchar or text fields of a table with about 2.6 millions records and going (it also joins with other smaller tables). Hope this helps. Qunfe

Re: Pattern Match on 3.23

Qunfeng, ..millions of records.. seems like a lot... Would you be kind enough to provide me with your hardware configuration? Thanks. At 07:57 AM 12/31/02 -0800, Qunfeng Dong wrote: If you are searching with %pattern%, your speed is depending on the speed of table-scan. The speed of tablescan de

Re: Pattern Match on 3.23

If you are searching with %pattern%, your speed is depending on the speed of table-scan. The speed of tablescan depends on your my.cnf setting (increase record buffer size?) and how big your records are. I am using pattern search here with millions of records and the performance is not terriblly to

Re: Pattern Match on 3.23

Qunfeng, Thanks for the feedback, I surely appreciate it. I asked the pattern match question, because I am using a hosting service that hosts MySQL 3.23. Since I have a need to search on terms less than 3 characters long and I can not re-compile, I was looking for another solution. I thought th

Re: Pattern Match on 3.23

It can perform pattern match on text field. The only draw back is the speed (especially if you are using %pattern% to do the search) when you tables are getting huge, since there is no index to help. Qunfeng --- Frank Peavy <[EMAIL PROTECTED]> wrote: > I would like to use pattern matching as a su

Pattern Match on 3.23

I would like to use pattern matching as a substitute to fulltext search on MySQL 3.23. Is this a good alternative? Are there any limits, like not being able to perform a pattern match on a 'text' field, etc., that I need to be aware of? Thanks.