Re: mysql becomes slow

winnecon writes: > > -- > 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 %val

Re: mysql becomes slow

-- 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

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Carsten H. Pedersen writes: >> >> ... >> >> > Having 27 indexes and using queries with LIKE "%...%" is a nice >> > recepee for slowness. >> >> Why should having 27 indexes slow down a SELECT? >> >> / Carsten >> --

RE: mysql becomes slow

Carsten H. Pedersen writes: > > ... > > > Having 27 indexes and using queries with LIKE "%...%" is a nice > > recepee for slowness. > > Why should having 27 indexes slow down a SELECT? > > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ > http://www.b

Re: mysql becomes slow

Carsten H. Pedersen schrieb am Samstag, 18. August 2001, 19:24:39: > Sinisa writes: >> Osus writes: >> > ... >> > Hi, >> > SELECT * FROM table WHERE OK=1 >> > it gets about 4 or 5 second at least. >> > I have indexes. That main table have 27 indexes to supply all >> > possible searches. > ...

Re: mysql becomes slow

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: mysql becomes slow

Sinisa writes: > Osus writes: > > ... > > Hi, > > SELECT * FROM table WHERE OK=1 > > it gets about 4 or 5 second at least. > > I have indexes. That main table have 27 indexes to supply all > > possible searches. ... > Having 27 indexes and using queries with LIKE "%...%" is a nice > recepee

Re: mysql becomes slow

Osus writes: > Hi, > SELECT * FROM table WHERE OK=1 > it gets about 4 or 5 second at least. > I have indexes. That main table have 27 indexes to supply all possible searches. > Some searches are made on text fileds, something like "WHERE field like '%key%' >being field text field. > > I have