2. PHPRunner General questions
  3. [SOLVED]  Slow site
This topic is locked
[SOLVED]

 Slow site

 		1/11/2011 11:25:57 AM
PHPRunner General questions
Z
 Zxenop author

Hi all

I got a big probelm with my site, for those who have seen my previous post (here) I was converting my databaase view to phprunner views because the database view where too slow.

Howhever even with PhpRunner views I still have slow pages. SQL request generated by PhpRunner take something like 2 or sec to be executed for 400 rows (my tables don't have much datas in them nothing more than 5000 for the biggest). And when I tried to access the page I have to wait something like 20 sec! for the page to load.
I have indexes and primary keys on all my tables, using EXPLAIN on the request show that the indexes or primary key are used (I don't have foreign keys through).
The database is a MySQL community edition in 5.1.48 and Phprunner is on version 5.2 build 5482
Does anybody have already faced that problem before ?
Sergey Kornilov admin 1/11/2011

Since you never provided any additional info - not sure how we can help here.
Z
 		Zxenop author 1/11/2011



Since you never provided any additional info - not sure how we can help here.



If you are talking about the other problem, well it's kinda resolved since I recreated all the pages, rather than converting them

If it's about this one then what info do you need ?
Sergey Kornilov admin 1/11/2011

We need to have access to your database and generated application to see what we can do. Post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
Z
 		Zxenop author 1/12/2011



We need to have access to your database and generated application to see what we can do. Post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.



Well it's a bit too late, truns out my request where using funtions that were slowing the requests, thanks anyway