2. PHPRunner General questions
  3. Screen frozen for more than 10 seconds
This topic is locked

Screen frozen for more than 10 seconds

 		12/23/2021 7:28:03 AM
PHPRunner General questions
D
 dannyschaepdrijver authorDevClub member

Environment :
PHPRunner 10.5
MSSQL database. (Size 66 GByte)
Database consist of +6.000 tables
Only 20 tables are used in the PHPRunner application

Issue :
Whenever I move to the 'Tables' in the development environment the screen freezes for more the 10 seconds. I have to wait that long before doing anything.
I have the impression that each time I want to access the 'Tables' screen, a complete load of all the objects of the database is executed.
This is very annoying when developing.
Is there a solution to get rid of these waiting times ?

PS. The performance of the application is perfect.
Sergey Kornilov admin 12/27/2021

It is really hard to tell what exactly is happening. I would suggest trying version 10.6 and if this doesn't help contact support directly.

fhumanes 1/2/2022

Hello,

This is my particular opinion and I hope not to offend anyone.

  • In the databases, you should work on schemes, in order to have control of the tables and know what schemes = applications, they belong.
  • Users must be available that can only access the set of tables in their scheme.
  • To share tables of a scheme in another scheme, views (database) must be enabled to manage the type of access from that scheme.

If these characteristics have been taken into account, basic for data control, no problem should be had.

If the user who connects to the database has access to everything, it is very likely that you can not solve your problem, to the hands, this has happened to me.

Greetings,
fernando
Sergey Kornilov admin 1/2/2022

I agree with Fernando, that, in a perfect world, an application should only have access to those tables that it needs. However we have to deal with legacy databases, third party controlled databases etc all the time. In either case this situation is not normal and can be fixed once we have enough info.