This topic is locked
[SOLVED]

 Slow data connection

7/23/2011 8:49:24 AM
PHPRunner General questions
A
ant author

I am running a database with about 10,000 records and am testing the database on a local server and then uploading the files. I've noticed as I've been adding to the tables & views the site has been slowing down considerably. It works better on my local server but when I test the site its much slower.
I notice that phprunner has a tickbox for search items on fields and if I should reduce the number of fields searchable to increase the speed. Sometimes when i'm updating a linked table the page seems to freeze and says loading.
I've tried phpmaker before and do not have this problem. I would like to use phprunner as it looks a lot better but I run my business from the site and need to speed up the response time.
Please can someone advise.

A
ant author 7/23/2011

Thanks for the link <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=59640&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />

A
ant author 7/24/2011

I've been following the advice on the link and it has help loading pages but I am still having a big problem when I link to a notes page with discussions from a client. There are only 3 fields to the link table, ID, linkID & Note which is a text where I copy email and other correspondence. This table seems to sometimes load and hang with the loading.
Any advice, please <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=59642&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />

A
ant author 7/24/2011

I think the problem may be with the database, I check with firebug and I get the following error;

myColumnDefs[id_cell] is undefined

[Break On This Error] {areaCodes[myColumnDefs[id_cell].key]=...e')?$(this).attr('style'):'');if(!i)
I checked the tables I there were some records with NULL values for the linkID. I deleted these records but I still get the same problem. This is happening only with one record the others are loading fine.
Can someone please explain.

Sergey Kornilov admin 7/24/2011

Antoine,
it's not clear if you talking about slow connection or about some kind of error. In both cases providing a meaningful advice is not possible without access to your application.
I recommend to 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.

A
ant author 7/24/2011

I've managed to narrow down the problem. I deleted the discussions linked to the particular record and then started again. I removed the Rich text editor and it worked. Afterwards I added it back as a editor to the text field.
It worked fine until I copied and pasted a particular email that I had sent to a client. Once I added that record it seemed to corrupt the database. I then had to delete the record via phpmyadmin which corrected the problem.
I am very confused as to why this happens, I think it may have something to do with the table inserted in the email body.

Sergey Kornilov admin 7/24/2011

All this is highly confusing.

A
ant author 7/24/2011

How do I load a different editor like ckeditor

A
ant author 7/24/2011

I managed to find the help on loading ckeditor at http://xlinesoft.com/phprunner/docs/rich_text_editor_plugins.htm
It seems that it has to do with the html coding in the text that I paste. If I paste the email using the paste as text only it accepts the record and doesn't corrupt the database.
If someone can assist further I will appreciate it as this way I loose the formatting of my messages.