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
--
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
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
>> --
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
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.
> ...
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
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
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
Hi,
I have one p3-800, 2 uwscsi hd , debian, apache 1.3.20, php4.0.5 and mysql 3.23.38
I have one web aplication with about 10.000 visits per day and about 8.000.000 pages
visited per month.
Only one database with about 15 tables, the main with about only 20.000 records.
The problem is that t
