Forum

problem of slowness
 
Notifications
Retirer tout

problem of slowness

30 Posts
3 Utilisateurs
0 Reactions
21.9 K Vu
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 4 Oct PM 17:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

I'm sur that is good solution, but for security reason we cannot do that.


 
Posté : 4 Oct PM 17:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

is it possible that's the problem is our data server is too slowly ?


 
Posté : 4 Oct PM 17:1010
(@babynus)
Posts: 14952
Membre Admin
 

Yes of course.

Or maybe just badly configured.


 
Posté : 4 Oct PM 17:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

I'm to try to create new empty data base... and restore the data base with backup


 
Posté : 4 Oct PM 17:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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)


 
Posté : 4 Oct PM 20:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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.


 
Posté : 5 Oct AM 00:1010
Dale Scott
(@dale)
Posts: 12
Active Member
 

Good luck! When everything works, I would very much like to hear what the cause was. Cheers.


 
Posté : 5 Oct AM 00:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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 ?


 
Posté : 5 Oct AM 10:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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 ?


 
Posté : 5 Oct AM 11:1010
(@babynus)
Posts: 14952
Membre Admin
 

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.


 
Posté : 5 Oct PM 13:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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 ?


 
Posté : 5 Oct PM 13:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

is it possible to send you my backup database to check the issues ?


 
Posté : 5 Oct PM 13:1010
(@durou-c)
Posts: 468
Contributor
Début du sujet
 

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]


 
Posté : 11 Oct AM 11:1010
(@babynus)
Posts: 14952
Membre Admin
 

Logged query does not seem to have issue.
Possibly it is due to stop of MySql.


 
Posté : 12 Oct AM 01:1010
Page 2 / 2
Share:
Retour en haut