Hi there,

I am currently a very satisfied user of DBISAM. However I am considering to migrate to ElevateDB, and I have some technical questions:

I got very confident with DBISAM product and using in small/medium companies with little IT support, DBISAM is extremely handy.

Seems to me that the same thing happens with ElevateDB

But I will have eventually some different needs and I want to see if ElevateDB can be used on this scenario:

1 - There is a customer that can have up to 20,000 clients of the same application, it is a marketing mining program used by phone attendants. Today is a plain ASP with a lot of servers. I want to make it easier, probably a JavaScript running on client side, with EXTJS as framework, and connection to some source of data. It can be webservice, but can it be ElevateDB SERVER? Which are the limits of ElevateDB, is there any feedback of a customer using it on high demand? I will be using delphi back-end, and many information stored on ElevateDB. Would be great to have all data on the same DB
2 - Like on DBISAM, can the ElevateDB server source code be changed or added some specific code? On DBISAM  there is the "procedure" where can activate an server side event.

Eduardo

Eduardo,

<< 1 - There is a customer that can have up to 20,000 clients of the same
application, it is a marketing mining program used by phone attendants.
Today is a plain ASP with a lot of servers. I want to make it easier,
probably a JavaScript running on client side, with EXTJS as framework, and
connection to some source of data. It can be webservice, but can it be
ElevateDB SERVER? Which are the limits of ElevateDB, is there any feedback
of a customer using it on high demand? I will be using delphi back-end, and
many information stored on ElevateDB. Would be great to have all data on the
same DB >>

You can only use up to 4096 concurrent sessions in an ElevateDB
configuration, so 20,000 is going to be a problem for a single
configuration/database.  You could split the load among multiple ElevateDB
Servers using multiple configurations/databases, and you could use
replication to keep them synched, but you'd have to do the load-balancing on
the front-end manually.

<< 2 - Like on DBISAM, can the ElevateDB server source code be changed or
added some specific code? On DBISAM  there is the "procedure" where can
activate an server side event.  >>

Yes, you can do the same with the ElevateDB Server:

http://www.elevatesoft.com/manual?action=viewevent&id=edb2&product=delphi&version=7&comp=TEDBEngine&event=OnServerProcedure

Tim Young
Elevate Software
www.elevatesoft.com

Thank you,

Did you have the chance to test this amount of connections (4096) succesfully?

For around 10 opened tables per session and using only simple table operations (I believe mostrly append) what would be the recommendation for the server, specially memory need?

This limit of 4096 is from ElevateDB or something else? Could it be possible to have 2 ElevateDB on the same server (different ports) if the computer can handle it?

I believe this is all I need to know.

Thank you !

Eduardo,

<< Did you have the chance to test this amount of connections (4096)
succesfully? >>

Yes, I've tested that many connections.  However, these are just simple
connection tests, not working applications.

<< For around 10 opened tables per session and using only simple table
operations (I believe mostrly append) what would be the recommendation for
the server, specially memory need? >>

You'll need to use the 64-bit server, and you should estimate about 256KB
per table, so 12-16GB should suffice.

<< This limit of 4096 is from ElevateDB or something else? >>

From ElevateDB.

<< Could it be possible to have 2 ElevateDB on the same server (different
ports) if the computer can handle it? >>

Yes.  You can even use named instances of ElevateDB Servers to allow you to
configure them all using the same .ini file (and without renaming the
edbsrvr.exe):

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Starting_Configuring_Server

under "Multiple Server Instances" at the bottom of the page.

Tim Young
Elevate Software
www.elevatesoft.com