Re: Search text without using search index
Khaled Mahmoud <[email protected]> Thu, 6 Jun 2013 07:08:25 -0700 (PDT)
| Newsgroups | gmane.comp.java.scarab.user |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_112_1092540650.1370549115535 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks. Please send my regards to "Amjad Darwish" ________________________________ From: FRED.YY.LIN =E6=9E=97=E5=AE=A5=E5=BB=B6 <[email protected]> To: [email protected]=20 Sent: Tuesday, June 4, 2013 10:56 PM Subject: Search text without using search index =20 Dear Users, We wrote a program to import batch data (about 500 issues each time) into S= carab each day. We had a problem that the quick search or other text search didn't work wel= l since data were dumped into MySQL directly. There were no text search ind= ex created for these issues. So we had to regenerate search index each time and it was time consuming. It could take couple of hours to finish the index regenerating when data gr= ow up day by day. Are the ways to by pass the search index and do the text search directly vi= a MySQL command ? Or is there a chance to let the search index just regenerate the incrementa= l part ? Regards, Fred.yy.Lin Delta Networks, Inc. 256 Yangguang Street, Neihu, Taipei 11491, Taiwan Tel: +886-2-8797-2088=C2=A0 ext.3443 or internal ext.: 112-3443 ************************************************************************* This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. [Delta Electronics, INC. Taiwan] ************************************************************************* ------------------------------------------------------ http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3D456&dsMessageId=3D30= 57230 To unsubscribe from this discussion, e-mail: [[email protected]= is.org]. ------------------------------------------------------ http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3D456&dsMessageId=3D30= 57268 To unsubscribe from this discussion, e-mail: [[email protected]= is.org]. ------=_Part_112_1092540650.1370549115535 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html><body><div style=3D"color:#000; background-color:#fff; font-family:ti= mes new roman, new york, times, serif;font-size:12pt"><div><span>Thanks.</s= pan></div><div style=3D"color: rgb(0, 0, 0); font-size: 16px; font-family: = 'times new roman', 'new york', times, serif; background-color: transparent;= font-style: normal; "><span>Please send my regards to "Amjad Darwish"</spa= n></div><div><br></div> <div style=3D"font-size: 12pt; font-family: 'times= new roman', 'new york', times, serif; "> <div style=3D"font-size: 12pt; fo= nt-family: 'times new roman', 'new york', times, serif; "> <div dir=3D"ltr"= > <hr size=3D"1"> <font size=3D"2" face=3D"Arial"> <b><span style=3D"font-= weight:bold;">From:</span></b> FRED.YY.LIN =E6=9E=97=E5=AE=A5=E5=BB=B6 <= [email protected]><br> <b><span style=3D"font-weight: bold;">To:<= /span></b> [email protected] <br> <b><span style=3D"font-weight: bold= ;">Sent:</span></b> Tuesday, June 4, 2013 10:56 PM<br> <b><span style=3D"fo= nt-weight: bold;">Subject:</span></b> Search text without using search index<br> </fo= nt> </div> <div class=3D"y_msg_container"><br>Dear Users,<br><br>We wrote a= program to import batch data (about 500 issues each time) into Scarab each= day.<br><br>We had a problem that the quick search or other text search di= dn't work well since data were dumped into MySQL directly. There were no te= xt search index created for these issues.<br><br>So we had to regenerate se= arch index each time and it was time consuming.<br><br>It could take couple= of hours to finish the index regenerating when data grow up day by day.<br= ><br>Are the ways to by pass the search index and do the text search direct= ly via MySQL command ?<br><br>Or is there a chance to let the search index = just regenerate the incremental part ?<br><br>Regards,<br>Fred.yy.Lin<br>De= lta Networks, Inc.<br>256 Yangguang Street, Neihu,<br>Taipei 11491, Taiwan<= br>Tel: +886-2-8797-2088 ext.3443 or internal ext.: 112-3443<br><br>**********************************************************= ***************<br>This email message, including any attachments, is for th= e sole<br>use of the intended recipient(s) and may contain confidential and= <br>privileged information. Any unauthorized review, use, disclosure or<br>= distribution is prohibited. If you are not the intended recipient, please<b= r>contact the sender by reply e-mail and destroy all copies of the original= <br>message. [Delta Electronics, INC. Taiwan]<br>**************************= ***********************************************<br><br>--------------------= ----------------------------------<br><a href=3D"http://scarab.tigris.org/d= s/viewMessage.do?dsForumId=3D456&dsMessageId=3D3057230" target=3D"_blan= k">http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3D456&dsMessage= Id=3D3057230</a><br><br>To unsubscribe from this discussion, e-mail: [<a ym= ailto=3D"mailto:[email protected]" href=3D"mailto:[email protected]">users-unsubscribe@scar= ab.tigris.org</a>].<br><br></div> </div> </div> </div></body></html> ------=_Part_112_1092540650.1370549115535--