Slow web page 10 Years, 7 Months ago
|
Karma: 0
|
Hi,
I've just purchased your Ari Data Tables extension and set it up successfully on my Joomla site - it is linking to a table inside the Joomla database fine, however it takes about 1 minute to load the webpage because it appears to be loading all the data straight away, is there no way to stop this? The table contains 23,000 records
I can private message you the URL so you can take a look,
Many thanks
Philip Wood
|
|
|
|
|
Re:Slow web page 10 Years, 7 Months ago
|
Karma: 760
|
Hello,
Set "Server side pagination" parameter to "Yes".
Regards,
ARI Soft
|
|
|
|
|
Re:Slow web page 10 Years, 7 Months ago
|
Karma: 0
|
Hi,
I've tried this but it doesn't change anything, the tooltip for thtat parameter says to enabled the plugin "ARI AJAX Dispatcher" but when that's updated it breaks the webpage, shows the following error:
'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,1' at line 1 SQL=SELECT * FROM aparts; LIMIT 0,1'
aparts is the Table within the Database.
Kind Regards,
Philip
|
|
|
|
|
Re:Slow web page 10 Years, 7 Months ago
|
Karma: 760
|
Could you send your SQL query?
Regards,
ARI Soft
|
|
|
|
|
Re:Slow web page 10 Years, 7 Months ago
|
Karma: 0
|
Sure,
It's:
SELECT * FROM aparts;
|
|
|
|
|
Re:Slow web page 10 Years, 7 Months ago
|
Karma: 760
|
Remove ; at the end of the query.
Regards,
ARI Soft
|
|
|
|
|
|