Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread OT: Number of connected users
Fri, Oct 28 2016 2:19 PMPermanent Link

Jose Eduardo Helminsky

HPro Informatica

Today one of my applications reach 190 connected (and active) users.
This is my personnal record and this will increase soon with more three branches of this customer.

There are four databases and around 20Gb in size and growing.
Around 80 users is handled by a terminal server (isolated from database server)

A lot of tips to give if someone wants to know.

Thanks DBISAM (and I hope ElevateDB soon)

Jose Eduardo Helminsky
Fri, Oct 28 2016 3:37 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Eduardo,

<< Today one of my applications reach 190 connected (and active) users. This is my personnal record and this will increase soon with more three branches of this customer.

There are four databases and around 20Gb in size and growing. Around 80 users is handled by a terminal server (isolated from database server) >>

Wow, that is impressive.  I would be hard-pressed to be able to accomplish the same, which is saying something. Smile

Tim Young
Elevate Software
www.elevatesoft.com
Fri, Oct 28 2016 3:42 PMPermanent Link

Huseyin Aliz

myBiss ApS

Avatar

Jose,

Very cool Smile

Regards,

Hüseyin

Den 28-10-2016 kl. 20:19 skrev Jose Eduardo Helminsky:
> Today one of my applications reach 190 connected (and active) users.
> This is my personnal record and this will increase soon with more three branches of this customer.
>
> There are four databases and around 20Gb in size and growing.
> Around 80 users is handled by a terminal server (isolated from database server)
>
> A lot of tips to give if someone wants to know.
>
> Thanks DBISAM (and I hope ElevateDB soon)
>
> Jose Eduardo Helminsky
>
Sat, Oct 29 2016 2:35 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Jose


I have to echo Tim's sentiment - WOW

Roy Lambert
Tue, Nov 8 2016 6:21 AMPermanent Link

kamran

Hello Jose

Jose Wrote:

"A lot of tips to give if someone wants to know."

So looks like you have squeezed DBIsam to the limit and made it work for you.
Thats good and great news. I am also a fan of DBISAM.

I have a similar requirement but not sure what is the best way to go about ?

I was curious how you solved in principle the way to have multiple branches using the same database.

1. Do you have a Separate database for each branch ?

2. Do you have a separate folder for each branch ?

3. How do you combine that data from each branch for reporting purposes ?

4. What about backups? how are they done ?

5. What is the hardware requirement / network structure for this ?

6. Anything else that you think is good for such a situation.

7. How does "Terminal Server" fit into / used by your system?

Hope that you could share your experience.

Kind regards


Kamran
Tue, Nov 8 2016 12:12 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kamran,

<< I was curious how you solved in principle the way to have multiple branches using the same database. >>

We have a mirroring DBISAM Database Server that I've written about here:

http://www.elevatesoft.com/blog?action=view&id=mirroring_dbisam_database_server_code

It will allow you to do a branch setup with a DBISAM database.  We use it to mirror data to/from our web server in Chicago.  Essentially you end up with two DBISAM Database Servers talking to each other in terms of data and backups.  For example, we have a scheduled event in our DBISAM Database Server here that every night does an FTP pull of the web server backups for data that is only stored on that server.

Tim Young
Elevate Software
www.elevatesoft.com
Tue, Nov 8 2016 12:12 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kamran,

<< I was curious how you solved in principle the way to have multiple branches using the same database. >>

We have a mirroring DBISAM Database Server that I've written about here:

http://www.elevatesoft.com/blog?action=view&id=mirroring_dbisam_database_server_code

It will allow you to do a branch setup with a DBISAM database.  We use it to mirror data to/from our web server in Chicago.  Essentially you end up with two DBISAM Database Servers talking to each other in terms of data and backups.  For example, we have a scheduled event in our DBISAM Database Server here that every night does an FTP pull of the web server backups for data that is only stored on that server.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Nov 9 2016 5:59 AMPermanent Link

Jose Eduardo Helminsky

HPro Informatica

Kamran

Lets go

<<
1. Do you have a Separate database for each branch ?
>>
No, just one database for the main application (a POS system). Altought it is multi-branch application, there are some tables in common like financial things that are wide to the company and not specific to some branch.

<<
2. Do you have a separate folder for each branch ?
>>
No. See answer 1.

<<
3. How do you combine that data from each branch for reporting purposes ?
>>
Basic (and fast) reports using only SetRange are usual but we have other server to produce the reports. Every night the database is mirrored to another server. Of course this reports only see data in (D-1 model)

<<
4. What about backups? how are they done ?
>>
This is not a 24/7 application and therefore, the backup is made during the night

<<
5. What is the hardware requirement / network structure for this ?
>>
Nothing special but we have 3 servers. 1) Database server, 2) Terminal Server 3) Report Server with the same features:  (32 Gb RAM, SSD and i7 processor) dedicated to the application. But these servers are only to the application.

<<
6. Anything else that you think is good for such a situation.
>>
1 - Use restricted transaction
2 - Keep the transaction time shortest as possible
3 - I have developed a special server application that receive commands from clients to perform database tasks. In this way the application avoid network issues accessing the database.

<<
7. How does "Terminal Server" fit into / used by your system?
>>
This company have around 20 branches around the country and their users connect to the application using a terminal server.

I hope it solve your doubts but if not, let me know

Regards

Jose Eduardo Helminsky
Wed, Nov 9 2016 6:29 AMPermanent Link

kamran

Thanks a lot:  Jose and Tim

Thats very useful and helpful to know.

Kamran


Jose Eduardo Helminsky wrote:

Today one of my applications reach 190 connected (and active) users.
This is my personnal record and this will increase soon with more three branches of this customer.

There are four databases and around 20Gb in size and growing.
Around 80 users is handled by a terminal server (isolated from database server)

A lot of tips to give if someone wants to know.

Thanks DBISAM (and I hope ElevateDB soon)

Jose Eduardo Helminsky
Image