DatabaseOpen() slow over network
X Y
xyzabc1010 at yahoo.com
Wed Apr 16 12:51:29 CDT 2003
Thanks For the ptrs.
It seems as though the time to open a db is
proportional to the # of tables and fields in the db.
I replaced the varchars --> string which reduce the
speed.
However, I played around with removing fields etc and
the opening time keeps going down.
Is there any work around to this?
Thanks
--- Ruslan Zasukhin <sunshine at public.kherson.ua>
wrote:
> on 4/15/03 11:40 PM, X Y at xyzabc1010 at yahoo.com
> wrote:
>
> > hmm maybe
> > is there a way to turn that off??
>
> In normal way Valentina must not do reindex each
> time.
>
> Only if something bad with index happens we can see
> such problem,
> So on open it start index, fail it, next open again
> start indexing.
> I do not think this is your case.
>
> Try do XML Dump / Load.
> After this any problem should go away.
> Do not trash original db :-)
>
> ---
> You can remove in VAPP all index flags.
> And try now.
> IF still slow for you, then I think you have a lots
> of VarChar fields.
> Then you can try convert some small of them to
> string field.
>
>
> In future I want fix this to make Open() time
> independent from this factors.
>
> --
> Best regards,
> Ruslan Zasukhin [ I feel the need...the need
> for speed ]
>
-------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
>
http://listserv.macserve.net/mailman/listinfo/valentina
>
-------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com
More information about the Valentina
mailing list