Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
High demand usage ElevateDB |
Wed, Feb 12 2014 8:44 AM | Permanent Link |
Eduardo | 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 |
Wed, Feb 12 2014 9:42 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Feb 12 2014 11:26 AM | Permanent Link |
Eduardo | 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 ! |
Thu, Feb 13 2014 9:11 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |