timeout problem with "large" table SOLVED

[Ruslan Zasukhin]

On 8/12/05 1:04 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

Hi Florian,

> This works so far but the problem are the field flags. Since a field might
> change e.g. from unique to not unique, I simply set all field flags for
> every field every time when I open the DB - either 0 or 1. For the flags
> unique and nullable this leads to the problem: addRecord() becomes terribly
> slow, the more records the slower. Setting indexed flag every time is no
> problem.
> 
> So while it may not be nice from me to make Vserver work so much, this is
> some weird bug inside Vserver, I do not understand.

Me too.

Nullable flag just add bitmap file for that field.
This is not many work.


Unique just change type of index. THIS operation will do REINDEX.
But only once.


-- 
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]