Performance Issue

The typical suggestion is to print SQL query on the page and run it against your database manually. If SQL Query itself is slow you need to check if indexes are in place etc.
How to print SQL Query on the page:

http://xlinesoft.com/phprunner/docs/debugging_tips.htm
You can also upload your application to Demo Account to see how it works there.

I uploaded to the demo account and it runs very fast. Could this mean there is a problem with the way the DB's are set up on GoDaddy?
Also, I have one design question. I have two main data tables. Table one is indexed by a field called PIN (property identification number). Table two contains the PIN but is not indexed. The two tables are related by PIN. When I tried to make the PIN in table two the primary key I had a number of issues. Does this matter or should I create a dummy field to index table two? Additionally, the PIN field is populated with the value from record one, but the field is not live on the add screen for table two??

Demo Account upload only transfers up to 1000 records per table. If your live database has more data it may run slower.
Without seeing the actual application cannot provide a meaningful advise. I would suggest open a ticket at http://support.xlinesoft.com sending providing both live and demo account application URLs. This way we can see if there is anything wrong with setup.

I have found RDP into Windows Terminal Server 2003 using IE8 Server 2003 Version and MySQL is marked slower that when accessing on the local network.
Have just set up PRISM (Firefox barebones) for localhost and found responses via RDP that were previously taking 7- secs were changed t almost instant.
Not sure if playing with your web browser will help in your situation but was surprised at the improvement.

Upd: this issue was caused by slow GoDaddy web server performance and eventually resolved itself.