Hi!

I'm using DBISAM 4 (latest release).

I have been reading about MaxTableDataBufferSize, ...BufferCount,
....IndexBufferSize, etc... properties, but I still have some doubts
regarding this.

I 'undesrtand' that those properties don't affect C/S connections, but only
local tables or file-sharing networks?
Nowadays, 90% of our customers have 1GB-2GB RAM, so I think I could use
these properties to improve our app speed.

Our app can be executed in C/S mode (lan or internet) and in file-sharing
mode, depending on customer decision (and money

So...
1) Do these properties improve C/S LAN speed (one server, several clients)?
2) Do these properties improve C/S INTERNET speed (one remote server,
several remote clients)?
3) Do these properties improve local files speed (only one computer)?
4) Do these properties improve shared-files network speed (one shared
server, several network clients)?

There are about 15 tables, with indexes. Some tables (only 3 or 4) have blob
field (only one per table).
In C/S mode, the speed is perfect, but in file-sharing mode (two or more
computers) it usually takes about 1 minute to search, locate, filter, etc...
with some tables. Is it possible to improve it?

Thanks a lot! I know this have been discussed a lot, but actually I don't
understand it. Maybe because of my poor english (I'm from Spain)

Luis,

<< I 'undesrtand' that those properties don't affect C/S connections, but
only local tables or file-sharing networks? >>

Correct.

<< 1) Do these properties improve C/S LAN speed (one server, several
clients)? >>

No.

<< 2) Do these properties improve C/S INTERNET speed (one remote server,
several remote clients)? >>

No.

<< 3) Do these properties improve local files speed (only one computer)? >>

Somewhat, but not a lot.

<< 4) Do these properties improve shared-files network speed (one shared
server, several network clients)? >>

Yes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi, Tim...

Is it enough to change the global 'Engine' session 'Max...........Size'
properties or should I do something else?

I change them before opening the sessions, but I have been testing and I
can't see any speed improovement.
When/Where do these properties make effect?



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> escribió en el
mensaje de
noticias:AA0E8272-9939-49D9-B9F5-D09B7ABC98F1@news.elevatesoft.com...
> Luis,
>
> << I 'undesrtand' that those properties don't affect C/S connections, but
> only local tables or file-sharing networks? >>
>
> Correct.
>
> << 1) Do these properties improve C/S LAN speed (one server, several
> clients)? >>
>
> No.
>
> << 2) Do these properties improve C/S INTERNET speed (one remote server,
> several remote clients)? >>
>
> No.
>
> << 3) Do these properties improve local files speed (only one computer)?
>  >>
>
> Somewhat, but not a lot.
>
> << 4) Do these properties improve shared-files network speed (one shared
> server, several network clients)? >>
>
> Yes.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Luis,

<< Is it enough to change the global 'Engine' session 'Max...........Size'
properties or should I do something else? >>

No, that is all you need to do.

<< I change them before opening the sessions, but I have been testing and I
can't see any speed improovement. When/Where do these properties make
effect? >>

They take effect immediately.  However, you may need to increase them quite
a bit before you see any improvement, and there is always the possibility
that your particular situation will not be helped by increasing them due to
other factors.

--
Tim Young
Elevate Software
www.elevatesoft.com