Hi!

We have DBISAM Servers (version 3.3) in many places.

Sometimes we need to get better performace.

In other database servers (like FireBird, MS-SQL) we can set many parameters to increase
performance (make better speed).
Like "pages hold in memory", "auto memory allocation", "proc. affinity", etc.

Which parameters can I set in this version of the dbisam server?

Have this server any hidden parameters that not configurable from administration
application? (Like memory pages, etc.).

We must speed up one server, and we must check the possibilities of the software
performance increasing before we pay for better hardware.

Thanks for your help:
dd

<< We must speed up one server, and we must check the possibilities of the
software performance increasing before we pay for better hardware. >>

The best way to increase performance is to recompile the DBISAM database
server with FastMM 4 included.  The default memory manager for Delphi that
DBISAM uses is pretty bad with multi-threading performance, especially on a
multi-processor machine.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

> The best way to increase performance is to recompile the DBISAM database
> server with FastMM 4 included.  The default memory manager for Delphi that
> DBISAM uses is pretty bad with multi-threading performance, especially on a
> multi-processor machine.

If i remember correctly i suggested to you to compile the dbisam
servers of all delphi editions with delphi 2006 (or better now with 2007).

So, since delphi 2006/2007 has fastmm built in it would give the
best perfomance of the server. (of course not using DBISAM's MM)

Aren't doing that now ?

eg. Delphi 7 installation contains a server compiled with delphi 7 ?

If that's the case then i would download Delphi 2007 installation
and use it's server ....

Am i clever or what ...

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Michael,

<< If i remember correctly i suggested to you to compile the dbisam servers
of all delphi editions with delphi 2006 (or better now with 2007).

So, since delphi 2006/2007 has fastmm built in it would give the best
perfomance of the server. (of course not using DBISAM's MM)

Aren't doing that now ? >>

No, DBISAM 4.x still uses its own memory manager and all servers are
compiled with Delphi 5.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:


<< We must speed up one server, and we must check the possibilities of the
software performance increasing before we pay for better hardware. >>
>
>The best way to increase performance is to recompile the DBISAM database
>server with FastMM 4 included.  The default memory manager for Delphi that
>DBISAM uses is pretty bad with multi-threading performance, especially on a
>multi-processor machine.

So there isn't way to increase memory buffers, or other parameter used by server?

Please help me a little.
If I see good, the server is only a multithreaded brige across the net.
It is seems to be a remote object that handle connections as local embeddeb library, but it is working local, and send/receive results through the
net...

I see this thing good?

thanks for the infos: dd

Tim

Why don´t you change DBISAMM to FASTMM in version 4 ? Always I´ve upgrade to
a new build, I have to recompile the server changing the memory manager. And
I think this situation is common for many users.

Eduardo

Eduardo,

no it is not. I use DBISAM or Nexus Memory Manager

Arnd

Arnd

Jose Eduardo Helminsky wrote:
> Tim
>
> Why don´t you change DBISAMM to FASTMM in version 4 ? Always I´ve upgrade to
> a new build, I have to recompile the server changing the memory manager. And
> I think this situation is common for many users.
>
> Eduardo
>
>

Arnd

But **IF** FastMM is better than DBISAM memory manager and it is free
then...

I don´t know Nexus MM but if it is better than FastMM and it is free, then
that is the way.

Eduardo

<< So there isn't way to increase memory buffers, or other parameter used by
server? >>

Yes, you can do so by modifying the memory buffer parameters on a
per-session basis.   See the documentation for the TDBISAMSession component
provided with the product.

<< Please help me a little.
If I see good, the server is only a multithreaded brige across the net.
It is seems to be a remote object that handle connections as local embeddeb
library, but it is working local, and send/receive results through the
net...

I see this thing good? >>

Yes, you're pretty much correct.  That's how it works as a basic
description.  However, DBISAM is not just a code library, it is a complete
database engine.

--
Tim Young
Elevate Software
www.elevatesoft.com