[V4RB2] 2.0.4fc5 crash - more info

[Ruslan Zasukhin]

On 6/11/05 5:09 PM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:

> I turned off compression (and sorting) and let my program run overnight. I
> ended up with 37,723 master records (e-mail) and 51,581 related records (the
> e-mail text). Searching for e-mail by it's text now takes about a second.
> 
> In other words, without compression, my program was able to add almost twice
> as many records in the same time frame and searches take almost no time at
> all, not the 2-minutes I saw earlier.
> 
> That it takes longer to add records is to be expected, and I don't mind. But
> the compression seems to be interfering with the searches.
> 
> As a next step, I am going to turn compression back on but turn off sorting
> and add records again. I just want to make sure that the problem with
> searching was due to compression and not the sorting bug I reported
> yesterday.

Actually strange results. Something wrong.

Compression affect only TEXT field itself.
It not touch indexes.

Kem, do you have indexes on that TEXT fields?
May be you do NOT-indexed searches ?!



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]