XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. Xoops Development / 
  3. Feature Request 
  4.  / XOOPS Config in File and Not MySQL DB
Register
1
pegasus00321
XOOPS Config in File and Not MySQL DB

In my quest to save DB Queries, I was thinking maybe the XOOPS Config stuff like site name, description, etc should be stored in a php file rather than in the DB. This is needed for every page and calling it from a DB is kind of a waste.

Less DB queries = less page time gen.
But seriously, that info is used for every page, why not make it faster...
2
pegasus00321
Re: XOOPS Config in File and Not MySQL DB

DEVs, what I mean by this is do what Mambo does basically, store the config in a php file rather than in the DB since the config has to called up for EVERY page.

Putting it in a file will speed things up a bit.
Pegasus00321


I would appricate it if you click this link
TuFat.com PHP Scripts and etc
3
pegasus00321
Re: XOOPS Config in File and Not MySQL DB

Oh wow, no one is interested in saving queries?
I mean, quering the config for every page isnt exactly conservative.
Pegasus00321


I would appricate it if you click this link
TuFat.com PHP Scripts and etc
4
Mithrandir
Re: XOOPS Config in File and Not MySQL DB

Must admit I haven't spotted this one before.

We are looking into several areas for optimisation and retrieving information on every request, when that information does not often change, is - as you say - rather unnecessary.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software
5
WarDick
Re: XOOPS Config in File and Not MySQL DB

  • 2005/8/16 8:53

  • WarDick

  • Just can't stay away

  • Posts: 890

  • Since: 2003/9/13


Good one Pegasus.

How about encrypting the database access info while you are at it?
Urging XOOPS to be the Best It Can Be.
Richard......
6
pegasus00321
Re: XOOPS Config in File and Not MySQL DB

Seriously, taking away 5 queries for config is saving quite a bit in terms of queries and thats a good bit of speed up.
Pegasus00321


I would appricate it if you click this link
TuFat.com PHP Scripts and etc
7
brash
Re: XOOPS Config in File and Not MySQL DB

  • 2005/8/17 4:20

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


Sounds like a logical idea to me...
IT Headquarters
Innovative IT Solutions
8
pegasus00321
Re: XOOPS Config in File and Not MySQL DB

I'd be willing to try and make this work.

Where is the XOOPS config handler located in?
Pegasus00321


I would appricate it if you click this link
TuFat.com PHP Scripts and etc
9
Mithrandir
Re: XOOPS Config in File and Not MySQL DB

/kernel/config.php
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software
10
Dave_L
Re: XOOPS Config in File and Not MySQL DB

  • 2005/8/20 10:33

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Quote:
taking away 5 queries for config is saving quite a bit in terms of queries


Isn't the config table retrieved using a single query?

----
edit

Hmmm, it looks like there are three config table queries for each page.
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

219 user(s) are online (141 user(s) are browsing Support Forums)

Members: 0

Guests: 219

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits