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.
Qunfeng --- Frank Peavy <[EMAIL PROTECTED]> wrote: > 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 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 too bad. Maybe > >you can still use fulltext search for general > cases; > >and use pattern match ONLY when you are searching > for > >3-char-term. You should be able to make such > "Switch" > >through your interface. > > > >Qunfeng > > > > > >--- Frank Peavy <[EMAIL PROTECTED]> wrote: > > > 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 that I might be able to use > > > pattern matching as a > > > substitute, but it sounds like performance might > be > > > an issue with large tables. > > > > > > If you have any other recommendations on how I > could > > > approach my problem, I > > > would surely appreciate them. > > > > > > > > > At 07:35 AM 12/31/02 -0800, Qunfeng Dong wrote: > > > >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 > > > 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. > > > > > > > > > > > > > > > > > > > > > >--------------------------------------------------------------------- > > > > > 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 > > > > > > > > > > > > > > > > > >__________________________________________________ > > > >Do you Yahoo!? > > > >Yahoo! Mail Plus - Powerful. Affordable. Sign > up > > > now. > > > >http://mailplus.yahoo.com > > > > > > > > > > >--------------------------------------------------------------------- > > > >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 > > > > > > > > > > > >__________________________________________________ > >Do you Yahoo!? > >Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > >http://mailplus.yahoo.com > > > >--------------------------------------------------------------------- > >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 > > > > --------------------------------------------------------------------- > 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 > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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
