Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Slow web page
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Slow web page
#49062
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
The administrator has disabled public write access.
 
#49063
Re:Slow web page 10 Years, 7 Months ago Karma: 760
Hello,

Set "Server side pagination" parameter to "Yes".

Regards,
ARI Soft
The administrator has disabled public write access.
 
#49065
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
The administrator has disabled public write access.
 
#49066
Re:Slow web page 10 Years, 7 Months ago Karma: 760
Could you send your SQL query?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#49068
Re:Slow web page 10 Years, 7 Months ago Karma: 0
Sure,

It's:

SELECT * FROM aparts;
The administrator has disabled public write access.
 
#49069
Re:Slow web page 10 Years, 7 Months ago Karma: 760
Remove ; at the end of the query.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 12