|
<< Click to Display Table of Contents >> Navigation: Telegram > 2020 > 05 > 18 > Telegram_2020-05-18T13 |
2020-05-18T13:22:09
data module
2020-05-18T13:22:53
Ok thanks
2020-05-18T13:44:32
It takes a while to wrap your head around the architecture of Pooled DB Connections
2020-05-18T13:45:33
But your UserSession becomes completely empty of DB Connections, Queries and Stored Procedures :)
2020-05-18T13:48:58
Alexandre wrote above to just put one DB connection on your UserSession — but I don't do this anymore unless it's a very small application. There simply isn't any sense in having the memory and I/O overhead of having hundreds of DB connections, when 5 is enough. Remember — all of these connections live inside your running IW app. So, unless you know that you'll never need to be able to scale your webapp — then just start with pooling and be done with it.
2020-05-18T13:49:37
Once you are used to the architecture, it's no more difficult than not doing it — and you're setup for scaling out of the gate
2020-05-18T13:58:08
I am a bit confused now about where to place the connection; On DataModule or on UserSession! According to the architecture of IW pool connection, where should it be placed and what are the advantages of placing on one or the other? I think this would help to choose where it fits best