2. PHPRunner General questions
  3. [SOLVED]  Refresh time on Dropdown dependent list
This topic is locked
[SOLVED]

 Refresh time on Dropdown dependent list

 		2/4/2011 10:58:24 AM
PHPRunner General questions
P
 Pkas author

Hi

System:

Mysql 5.1

Php 5.2
I've 2 tables linked by id_ (id_local, local) and (id_city,city,local_fk).

In the form the link field is id_city, display field cityand dependent dropdown is local_fk.
When adding/editing a record in database the time spent waiting for the refresh of data is excruciating!( 2 to 5 sec)
Where can i take some measures to acelerate the refresh the dropdown list?
Tks
Sergey Kornilov admin 2/4/2011

Dependent dropdown pulls data from the database. Response time depends on how much data needs to be retrieved, if database is indexed properly and the speed of your internet connection.
If you want us to troubleshoot this 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.
P
 		Pkas author 2/9/2011



Dependent dropdown pulls data from the database. Response time depends on how much data needs to be retrieved, if database is indexed properly and the speed of your internet connection.


The data pulled by the query are from 15 records to at the most 100 records.

The index are ok.
So i tested the connection to server and was reallllyyy sslllooowwwwlllyyyy! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=56346&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=56346&image=2&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=56346&image=3&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />
So i'm sorry to bug you with a problem that was not a software problem but a hardware. I thougt it was a rolls-royce!!

Sometimes virtualization is not the solution...
Tks!!