[V4RB2] 2.0.4fc5 crash - more info

[Kem Tekinay]

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.


On 6/11/05 5:28 AM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> On 6/11/05 7:30 AM, "Kem Tekinay" <ktekinay at mactechnologies.com> wrote:
> 
>> On 6/10/05 1:07 AM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:
>> 
>>>> I then started searches and, while they were successful, I found that
>>>> searches run on a compressed VText field in related records were taking
>>>> almost two minutes each even though the field was indexed by words.
>>> 
>>> What you mean in related? You do join on 2 tables?
>> 
>> Yes, my database had 5 tables and 4 Binary Links. One of the tables is for
>> e-mail, and another is for the text of the e-mail in a VText (O::M Binary
>> Link). Searches of e-mail by the message text in the related records used to
>> take 2 seconds, but now they are taking almost two minutes. Other than
>> 2.0.4fc5, the only other difference is compression. (My original test was on
>> 2.0.x, but I don't remember specifically which version.)
>> 
>> I will turn off compression to see if this makes a difference and let you
>> know.
> 
> Right, this is the first step to check.


__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
545 Eighth Avenue, Suite 401                          Pager (917) 491-5546
New York, New York 10018                    http://www.mactechnologies.com

To join the MacTechnologies Consulting mailing list, send an e-mail to:
  mactechnologies_consulting-subscribe at yahoogroups.com