Products

Price/Order

Support

Partners

Testimonials

Test Results

About us

Contact
 database?
Bottom
 
Total posts: 4
 Author database?
Sally Peck

06.06.2007 05:21:29
Registered user
what kind of database session control do you recommend?
Danijel Tkalcec [RTC]

06.06.2007 10:08:57
Registered user
I am not entirely sure what you mean by database session control. If you are asking how to maintain your database connections so that you don't need to open/close them with every request, I'd recomment writing a database connection pool for your specific database access components. The pool should open a new connection when you need one and keep unused connections active for later use.

You can find an example of a database connection pool implementation (this one is for Firebird using IB*Objects) here:
Database connection pooling

Best Regards,
Danijel Tkalcec
Sally Peck

08.06.2007 09:26:33
Registered user
do you have an example that uses AnyDac?

e.g., the one posted on your partner web-pages.
Danijel Tkalcec [RTC]

09.06.2007 04:53:57
Registered user
Sorry, there is no example using AnyDAC, but the principle is the same for all database. If you are familiar with AnyDAC, you should be able to write a connection pool for the components you use. Just look at the example code for IBO, read the explanation and you should be good.

PS. If you have a ThinDAC license, or a support contract with Dmitry for AnyDAC, I am sure he will be happy to help you write that database connection pool.

Best Regards,
Danijel Tkalcec