From: Ori Folger <ori@co...> - 2001-02-03 20:18:15
2/3/2001 21:17:13, Arno Hollosi <ahollosi@...> wrote:
>So, whenever the page got displayed IsWikiPage() got called 300 times,
>which translates to 300 SQL queries for one page. The web server almost
>came to a halt due to mysql eating up all its resources.
For my own wiki (rashreshet.org, it's in Hebrew) IsWikiPage() is caching results from previous calls, and can also check for multiple pages with one call.
So I call it once with all the linked pages in the displayed page, which uses one SQL query, and it's done.
From: Pablo Roca Rozas <proca@cl...> - 2001-02-05 02:13:45
I have a problem with two of my ISP's, they don't allow me to change
to LANG setting and caused by this the traslation system don't work.
You builded phpwiki for working with Po files and so.
My point is another:
Hardcoded translations, putting inside the php a special mark
and them with a program that preprocess all this marks and translating
all before uploading. After that no need to call funcs neither gettext
or what others have: a SQL text table, tons of variables...
Here is an approach by Carlos Viana that I like:
I know this should be changed a bit, but Carlos is very active and
accepts all suggests, so one of my first would be that the special
chars can be %%%text%%%
What do you think?
Pablo Roca (proca@...)
Clavo Congelados, S.A. (http://www.clavo.net)
La Coruna - Espana
> Hardcoded translations, putting inside the php a special mark
> and them with a program that preprocess all this marks and translating
> all before uploading. After that no need to call funcs neither gettext
> or what others have: a SQL text table, tons of variables...
Hm - the gnu textutils save us a lot of headaches. It's easy to keep the=20
files up to date, ....
If you have problems with php's safemode then I suggest the following:
replace all occurneces of gettext() with mygettext() and modify the gette=
check in config.php, so that your mygettext() is used.
I've attached a perl-script for doing replaces on a file list.
Quite handy tool -- you have to know perl regexps -- just be careful and=20
don't forget to escape regexp chars like '('. I suggest making a backup o=
the files first.