"global" session for all users

Pompiuses

I'm working on a multilingual site. All texts in all languages are saved in a database. This means that for each page a user enters the database must be accessed to fetch the texts for the page. This is choking the database.

So what I need, ideally, is to put all the text from the database into memory where all users can access it. Some sort of global or common session for all users.

Can this be done in PHP??

laserlight

If it is "choking" the database, and your filesystem can handle this better, then change the system to use files instead of the database (which would be what this "global session" would do, anyway).

If using files wont make a difference, or even make it worse, then it's time you look towards a better hosting solution.

Pompiuses

Originally posted by laserlight
If it is "choking" the database, and your filesystem can handle this better, then change the system to use files instead of the database (which would be what this "global session" would do, anyway).

If using files wont make a difference, or even make it worse, then it's time you look towards a better hosting solution.

It was a filesystem previously and performance was fine.

As the site got bigger, with more languages, the need for external translators became an issue. So it was made a solution where the tranlsators just log on to a web-gui and, and translate texts from english to their native languages. It was then decided to store the texts in a database.

So is there really no way to do this in PHP? I know it's possible in ASP.......

mrhappiness

php does not offer an application object if that is what you meant

but if the file based solution was faster than reading the translations from the database why don't you create files based on the database's content?

Pompiuses

Originally posted by mrhappiness
php does not offer an application object if that is what you meant

but if the file based solution was faster than reading the translations from the database why don't you create files based on the database's content?

It's an option. But involves a lot of work. Was hoping to avoid that...

mrhappiness

lot of work?
why?