Forum

problem of slowness
 
Notifications
Retirer tout

problem of slowness

30 Posts
3 Utilisateurs
0 Reactions
21.9 {numéro}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é : 04/10/2017 5:22 pm
(@durou-c)
Posts: 468
Prominent Member
Début du sujet
 

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


 
Posté : 04/10/2017 5:24 pm
(@durou-c)
Posts: 468
Prominent Member
Début du sujet
 

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


 
Posté : 04/10/2017 5:24 pm
(@babynus)
Posts: 14952
Membre Admin
 

Yes of course.

Or maybe just badly configured.


 
Posté : 04/10/2017 5:43 pm
(@durou-c)
Posts: 468
Prominent Member
Début du sujet
 

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


 
Posté : 04/10/2017 5:57 pm
(@durou-c)
Posts: 468
Prominent Member
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é : 04/10/2017 8:45 pm
(@durou-c)
Posts: 468
Prominent Member
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é : 05/10/2017 12:18 am
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é : 05/10/2017 12:42 am
(@durou-c)
Posts: 468
Prominent Member
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é : 05/10/2017 10:41 am
(@durou-c)
Posts: 468
Prominent Member
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é : 05/10/2017 11:04 am
(@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é : 05/10/2017 1:00 pm
(@durou-c)
Posts: 468
Prominent Member
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é : 05/10/2017 1:08 pm
(@durou-c)
Posts: 468
Prominent Member
Début du sujet
 

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


 
Posté : 05/10/2017 1:30 pm
(@durou-c)
Posts: 468
Prominent Member
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/10/2017 11:07 am
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 12/10/2017 1:15 am
Page 2 / 2
Share:
Retour en haut