Re: mysql becomes slow

2001-08-20 Thread winnecon
-- I am having the same kind of difficulty. Slow returns on results. It may be bad database architecture or implementation (perhaps both), but I need to be able to pick out text fragments . . . like %value%. I understand that indexes do not help with "LIKE %value%" queries, is there anythin

Re: mysql becomes slow

2001-08-18 Thread winnecon
I am having the same kind of difficulty. Slow returns on results. It may be bad database architecture or implementation (perhaps both), but I need to be able to pick out text fragments . . . like %value%. I understand that indexes do not help with "LIKE %value%" queries, is there anything els

RE: Wild-card search problem

2001-07-30 Thread winnecon
command line interface? >>> >>>If it is the former, I would imagine there is a problem with your script. >>> >>>HTH >>> >>>Sam Masiello >>>Software Quality Assurance Engineer >>>Synacor >>>(716) 853-1362 x289 >>&g

RE: Wild-card search problem

2001-07-30 Thread winnecon
f it is the former, I would imagine there is a problem with your script. > >HTH > >Sam Masiello >Software Quality Assurance Engineer >Synacor >(716) 853-1362 x289 >[EMAIL PROTECTED] > > -Original Message- >From: winnecon [mailto:[EMAIL PROTECTED]] >

Wild-card search problem

2001-07-30 Thread winnecon
-- I have searched through all of the MySQL documentation I can get my hands on, but still have no explanation for the following "wild-card search" problem. I enter the following query: SELECT name,keywords,description from database_t where 1 and name like "p%" LIMIT 0, 30; -- or -- SELECT