Trust ID PBCEX logo 300x102

Database definition and performance?

8 years 2 months ago 8 years 2 months ago by Marcel Oosterhof.
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Topic Author
Database definition and performance? #3433
Hi Gentlepeople,

got a question about the performance of the database connection. As we know the connection closes between every successful query... our customer asks how many users can be handled because every login to the database is a cost-intensive operation. Do you have any experience with a big user quantity or are there any optimations to the database server himself?

Best regards Ingo

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)
8 years 2 months ago 8 years 2 months ago by Marcel Oosterhof.
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Database definition and performance? #3434
Hi Ingo,

Database performance is something we never receive complaints about, which means that I cannot tell much about the size of the database people use. We had once a report about a table with a million records, which required clever use of level-three filters to get it perform, but even that worked fine in the end. Maybe one of our distributors can say something about this?

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
The following user(s) said Thank You Ingo Sterthaus
8 years 2 months ago
JHicks
Moderator
Moderator
Posts: 64
More
Database definition and performance? #3438
I have some experience with large databases and CardExchange, and performance is not a problem for us.
I have tested with 300,000 unique MS SQL records unfiltered and the queries load in a couple of seconds.

However we also have a site that has 75 CardExchange Clients connecting to an SQL server, and the customer complained that they needed a license for each pc/user to connect to the server. So there was a larger dollar cost involved, but not a performance cost.

Jason Hicks MBA
National Service & Projects Manager
[Practical Peripherals Corporation Pty Ltd (Australia) http://www.ppc.com.au ]
"No we don't really eat much Kangaroo meat here, Cows are much easier to catch"
The following user(s) said Thank You Ingo Sterthaus
8 years 2 months ago
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Topic Author
Database definition and performance? #3439
That's good to hear! Thanks Rutger and JHicks.

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)