unfortunately this is necessary as there is the need of pre-compiling the CPL script before using it.
IF you want to rebuild the table (A) used by openser based on another table (B), you should consider minimizing the impact by using something like "last_modified" field in the table B; you should re-build only records modified since the last re-build.
other options will be to have in CPL-C module an auto-compile option - if the compiled format is not found in DB, do it during the first usage and store it in DB.
regards, bogdan
Andreas Sikkema wrote:
On Tuesday 05 December 2006 09:14, Bogdan-Andrei Iancu wrote:
( openserctl fifo LOAD_CPL sip:user@domain /path/his_cpl_file.xml )
How would one do this where there are lots (say, thousands) of users? Does this method scale?
Currently I'm rebuilding several tables from a separate database every couple of hours to make sure that the user settings are correct and in sync with my main database. At this moment I just copy data between a couple of tables. If I wanted to start using CPL I'd have to run a command line application for every user. I have this feeling that this might be a little clumsy and not that fast...