2. PHPRunner General questions
  3. Speed and performance
This topic is locked

Speed and performance

 		11/4/2016 6:59:44 AM
PHPRunner General questions
mbintex author

Hi,
I am asking myself how to improve my work efficiency. What are best practices?

  • the tables screens with relations renders quite slow on my core i7 computer. I have round about 24 tables, 10 relations, a dozen of custom views. It takes half a minute or so to see that on screen. I even get the message "no response from phpRunner" for a while. How can that be improved. My solution should grow ...
  • generating the solution with currently 2400 files to generate takes half to full minute. This is OK, if you want to see the changes for bigger work. But what if you have a script where you just fiddle around with things - especially if you are a beginner - and always have to wait that long, just to see - oh, this doesn´t work either. Is there any way to generate only the changes? Or is their another better way to check, whether a small addition to a script would change the game or not?
    How are you dealing with it? Or do I have to buy a faster computer?
    Regards
    Martin
Sergey Kornilov admin 11/4/2016

Use partial build in PHPRunner. It only builds those files that are required and is much faster. Perfect for local testing.
Use a full build when you need to deploy your solution to the web server.
J
 		jackwood 11/4/2016

Improve your Hardware with Add your RAM and change your drive to SSD.
mbintex author 11/4/2016



Use partial build in PHPRunner. It only builds those files that are required and is much faster. Perfect for local testing.
Use a full build when you need to deploy your solution to the web server.


Partial build sounds interesting.
mbintex author 11/4/2016



Improve your Hardware with Add your RAM and change your drive to SSD.



My notebook already has 12 MB of RAM and a 256 GB SSD.
Sergey Kornilov admin 11/4/2016

Btw, partial build is a default option.
mbintex author 11/5/2016



Btw, partial build is a default option.


Perhaps I changed that without much thinking right at the beginning.
How about the rendering speed of the tables screen - I really sit here waiting for that ...
K
 		Khampol 12/20/2016

12 MB



It would be prefered 12 Gb...
I use also a notebook with i7 with 16Gb ram but I feel that my desktop i5 8 Gb ram is "a bit" faster, i dunno why....
mbintex author 12/21/2016



It would be prefered 12 Gb...
I use also a notebook with i7 with 16Gb ram but I feel that my desktop i5 8 Gb ram is "a bit" faster, i dunno why....


Sure it´s GB and not MB :-)
9.6 made the screen drawing a little faster, but still there is a "thinking pause".
K
 		Khampol 12/21/2016

still there is a "thinking pause"


Maybe try to check if some applications (/or spyware...) which start with the OS and could take some cpu ressource which cause performance lost... (Glary utilities pro... Google it....)
mbintex author 12/21/2016



Maybe try to check if some applications (/or spyware...) which start with the OS and could take some cpu ressource which cause performance lost... (Glary utilities pro... Google it....)



none of that - only Onedrive, Nvidia and Realtek and Samsung printer drivers, Skype, Defender and "Send to onenote" - kind of "official" stuff
jadachDevClub member 12/21/2016

Not sure how big your data sets are and I don't know what kind of database you are using. However, in my case, using MS SQL Server; I make sure the relevant fields are indexed. That makes a world of difference regarding speed.
mbintex author 12/22/2016



Not sure how big your data sets are and I don't know what kind of database you are using. However, in my case, using MS SQL Server; I make sure the relevant fields are indexed. That makes a world of difference regarding speed.


As I mentioned before:
"I have round about 24 tables, 10 relations, a dozen of custom views." Today it´s a bit more, but not twice as much.
All tables have indexed ID fields, database is a remote MySQL database. 100Mbit Internet is available.
K
 		Khampol 12/22/2016

kind of "official" stuff



Ok, worst than i though.... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=80958&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=80958&image=2&table=forumreplies' class='bbc_emoticon' alt=':D' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=80958&image=3&table=forumreplies' class='bbc_emoticon' alt=':D' />
Sergey Kornilov admin 12/22/2016

I have no idea why this thread is being resurrected. We were in contact with the customer many times and figured out that using a different video card produces different results which this is a hardware issue that is not related to PHPRunner. I'm closing this thread as non-constructive.