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

XOOPS MyMenus 1.54.0 Beta 10

11/18 11:08 Mamba
Re: XOOPS MyMenus 1.54.0 Beta 7

11/18 11:06 Mamba
Re: XOOPS MyMenus 1.54.0 Beta 7

11/16 12:32 liomj
Re: XOOPS MyMenus 1.54.0 Beta 7

11/15 18:06 Mamba
Re: XOOPS MyMenus 1.54.0 Beta 7

11/15 5:33 liomj
Re: XOOPS MyMenus 1.54.0 Beta 7

11/15 5:29 liomj
Re: XOOPS MyMenus 1.54.0 Beta 7

11/15 4:39 Mamba
Re: XOOPS MyMenus 1.54.0 Beta 7

11/15 3:50 liomj
Re: XOOPS MyMenus 1.54.0 Beta 7

11/15 3:31 Mamba
Re: XOOPS MyMenus 1.54.0 Beta 7

11/15 1:48 Mamba

Who's Online

425 user(s) are online (315 user(s) are browsing Support Forums)

Members: 0

Guests: 425

Donat-O-Meter

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