[V4RB2] 2.0.4fc5 crash - more info

[Kem Tekinay]

Any reply to this? I really need to know why the VText searches are taking
so long.

On 6/8/05 9:55 PM, Kem Tekinay at ktekinay at mactechnologies.com wrote:

> I determined yesterday that my crash occurred when I tried searching my
> database while there was also a loop in a socket that was adding records. It
> turns out that I can crash the app, and corrupt the database, very easily by
> doing this, even though I can't figure out why. It's not a thread, after
> all, and I'm pretty sure this was not an issue before.
> 
> As a test, I let my app run and add records overnight without a problem.
> This morning, after about 22,000 records, I stopped the loop, quit the app,
> and restarted it. So far so good.
> 
> 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.
> Previously, I had reported that such searches had taken around 2 seconds on
> even more records. The only difference between that test and this one (apart
> from the different version of V4RB2) is that the VText field is now
> compressed.
> 
> Thinking that perhaps the indexes were damaged, I quit the app, deleted the
> ".ind" file, and restarted my app. After a bit of a delay, my app started,
> but the index file was less than half the size of the one I had deleted.
> 
> I ran a search on a non-compressed VVarChar field in the master records and
> that worked. I then tried the related, compressed VText field, but got an
> Exception ("compressor error"). My app crashed and I could not start it
> again. When I opened the data files in VStudio, all of my tables, and the
> data, were gone.
> 
> Ruslan, does any of this give you a clue as to what may be going on? And
> should searches on compressed VText fields take longer than ones on
> non-compressed VText fields?

__________________________________________________________________________
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