Persistent Connection Overhead [Q and A] - XOOPS Web Application System

XOOPS

Forum

Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk

Persistent Connection Overhead

2004/5/6 23:15
WarDick
Just can't stay away
Posts: 890
Since: 2003/9/13

Does anyone know what the memory overhead is for persistent Database connections per connection?

I am trying to determine connection limits.

Re: Persistent Connection Overhead

2004/5/7 3:03
DonXoop
Posts: 1171
Since: 2003/11/27

I don't know off hand but you should check the MySQL site for specifics. I don't know about ODBC but the native client makes very quick (inexpensive) connections.

Note that you build up as many connections as you have web server threads. This can be a problem on a hosted server with many threads. And for a db server local to the web server it makes no sense. A remote server can sometimes benefit but it depends on other factors.

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Jul 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

Persistent Connection Overhead

Re: Persistent Connection Overhead

Login

Search

Recent Posts

PHP 8.4.0 Alpha 1 released

Overview of the Composer packages in Admin

Re: xoops_getBaseDomain

xoops_getBaseDomain

Re: Test 3

Test 3

Re: Test2

Re: Test2

Re: Test2

Test2

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}