Re: Xoops DB Question [Xoops Development] - 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

1

Xoops DB Question

2004/9/30 0:21
jmass
Friend of XOOPS
Posts: 524
Since: 2003/12/18

When I turn on MySQL debug, I get a long list of queries. My question is:

Does XOOPS create a connection to the DB for each of these queries, or does using "$xoopsDB->query($sql)" (in other words the XoopsDB class) do some form of connection pooling for me?

Thanks,

JMass

2

Re: Xoops DB Question

2004/9/30 14:50
jmass
Friend of XOOPS
Posts: 524
Since: 2003/12/18

No help from a kind Dev???

JMass

3

Re: Xoops DB Question

2004/9/30 15:45
intel352
Module Developer
Posts: 824
Since: 2003/11/23

that's a good question, i'm not sure

i'd bet it still makes a connection each time, but i'm no guru, so it's best to wait for a core dev's answer

4

Re: Xoops DB Question

2004/9/30 17:26
ackbarr
Posts: 1449
Since: 2002/10/2

only one db connection is made per page request, which is enforced by the XoopsDatabaseFactory::getDatabaseConnection(); function. The global $xoopsDB object is generated via this function (see /include/common.php).

5

Re: Xoops DB Question

2004/9/30 17:53
jmass
Friend of XOOPS
Posts: 524
Since: 2003/12/18

Very cool!

I was really hoping to hear that!

JMass

6

Re: Xoops DB Question

2004/9/30 18:31
intel352
Module Developer
Posts: 824
Since: 2003/11/23

nice, i'm glad my guess was incorrect

shows how much i know, ehehe

Login

Username

Password

Remember me

Register now! | Lost Password?

Search

Advanced Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

3/16 2:02 Mamba
Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

3/14 20:34 hnn_gerd
Re: NewBB v 5.1.0 b 6

3/7 12:07 Mamba
Re: NewBB v 5.1.0 b 6

2/23 2:57 Mamba
NewBB v 5.1.0 b 6

2/17 18:57 spierrard
Re: XOOPS 2.5.11 search user is not working

2/14 13:11 Mamba
Re: oledrion

2/14 11:29 Mamba
Re: oledrion

2/13 15:22 oswaldo
Re: oledrion

2/12 19:20 Mamba
Re: oledrion

2/12 16:02 oswaldo

Who's Online

147 user(s) are online (104 user(s) are browsing Support Forums)

Members: 0

Guests: 147

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Apr 30
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 }}