I would my data base same as demo !!! please
we provide hosting service that will provide same performance.
And we can import your existing data.
If you are interrested, contact use through contact form.
I'm sur that is good solution, but for security reason we cannot do that.
is it possible that's the problem is our data server is too slowly ?
Yes of course.
Or maybe just badly configured.
I'm to try to create new empty data base... and restore the data base with backup
I did a new Projeqtor directory name ProjeqtorTest from version 6.4.1,
I'd copy on PhpMyadmin the database and rename,
when I log to the new ProjeqtorTest, I'd the First page configuration, to link the database, password etc...
I'd the connection page, I'm connect, and I have no error message but white page ?????
On console, I have message:
Failed to load resource: the server responded with a status of 404 (Not Found)
So i search little bit more and i have found my mistake. Now i have create a new empty database. Now i will try to dowload on the empty new database my backup of actual database, i hope that it will work and it will go faster. Sorry for my poor english.
Good luck! When everything works, I would very much like to hear what the cause was. Cheers.
so, I did a new folder Projeqtor Test in WWW folder with 6.4.1 version, when I connect on first page, I create a new database name ProjeQtorTest, I can connect it. The new database is ready and empty.
After that, I'm connect to the phpMyadmin, and import the backup of my actually data base.
Now when I'm connect to the projeqtorTest, I've the screen login, I use my login, it's works, but I've a totally white page!
if I go to the console of the browser, I have this (show in attached files)
what's wrong ?
I found the mistake with the log files, I've not install the plugins...
now with plugin the new database is exactly the same as the old one. But exactly the same slowness ...... :dry:
I do not understand ? is it possible to slow database with customization plugin or other plugin ?
Standard plugins may not cause perf issue. But if you designed your own, it can be soyrce of bad perf.
First a good test would be to try with brand new database : is perf bad without data ?
If yes : your infrastructure is the issue.
If no : install all your plugins : is perf bad with plugins ?
If yes : your plugins is the issue.
If no : install backup of data : if perf is bad, your data is the issue.
thanks for your reply.
I did new install. perf good
i install plugin : perf good
I import data : perf bad !!!
i have issue on data ... But how can I fixed it ?
is it possible to send you my backup database to check the issues ?
I have restart the PC from Projeqtor install today.
when I'm logging to Projeqtor and check the log files, I found some errors:
2017-10-11 08:28:21.533 ** ERROR ** [V6.4.2] Exception-[70100] SQLSTATE[70100]: : 1317 Query execution was interrupted
2017-10-11 08:28:21.534 ** ERROR ** [V6.4.2] For query : select * from indicatorvalue where idle='0' and ( ( warningTargetDateTime<='2017-10-11 08:28:21' and (warningSent='0' or code = 'YEARLY')) or ( alertTargetDateTimequery called at [/var/www/projeqtor/model/persistence/SqlElement.php:2253]
2017-10-11 08:28:21.534 ** ERROR ** [V6.4.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/Cron.php:372]
2017-10-11 08:28:21.534 ** ERROR ** [V6.4.2] #2 Cron->checkDates called at [/var/www/projeqtor/model/Cron.php:312]
2017-10-11 08:28:21.534 ** ERROR ** [V6.4.2] #3 Cron->run called at [/var/www/projeqtor/model/Cron.php:270]
2017-10-11 08:28:21.534 ** ERROR ** [V6.4.2] #4 Cron->relaunch called at [/var/www/projeqtor/tool/cronRelaunch.php:30]
Logged query does not seem to have issue.
Possibly it is due to stop of MySql.

