main logo
Subject: Re: Erik, text problem
Author: Erik Mueller-Harder
Posted: 2001/04/29 12:24:31
 
View Entire Thread
New Search


> do I remember correctly that you once have had a TEXT field,
> which after next WRITE(value) work very very long and become
> very very big ?

Actually, it was the first message in the "Still problems with
Text & indices" thread, from 19 April.

The problem showed up consistently when I created an empty
database, added 100,000 records with empty Text fields, and then
updated those empty Text fields with data. The new data was
_not_ usually very large -- usually 1K to 4K, with occasional
records with 16K or 32K.

After updating 30,000 records or so, the updating begins slowing
down dramatically, so that it takes a good minute or so to add
even a few words to an empty Text fields.

> Looks very similar to bug I have fix in VJDK.SetPicture()
> Yes, only VJDK and ONLY Picture.
>
> But may be in kernel in TEXT field also there is similar
> culprit in case of
> TEXT > 32KB ?
>
> Can you try reproduce this problem adding TEXT > 32 KB ?

What I was doing seldom involved fields of that size. I suppose
I could figure out a way to set up a test if you needed it, but
it would take a while.

I _am_ preparing to test the devil out of long VarChar fields, however.

If you still would like extra-long Text fields tested in a few
days, please let me know and I'll see what I can set up for you.

-- Erik

-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
 
©2001 Erik Mueller-Harder
<-- Prior Message New Search Next Message -->