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


Recent Events
  • 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.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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?

Best practice with large database (help!)
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Best practice with large database (help!)
#14993
Best practice with large database (help!) 12 Years, 11 Months ago Karma: 0
I am using ARI Data tables to display results of a query from a library. The table has about 6000 entries (medium sized library), and my SQL is like

select title, checkedout, author, dewy from pbt_library;

This works, although there is a good 10 seconds loading time, and I am concerned that this is a) a strain on the server and b) a strain on bandwidth. c) a strain on the browser to hold the resulting mile long HTML.

I dont expect heavy usage, but that table as a csv is over 1M, and with just those fields selected, I bet theres around 400k of data...

Basically, Im concerned for the well being of my users browsers lol. ARI holds up fine, but to view the source, the page is a mile long!

I could split up the database, have 2, like a link [search A-M], and another [search N-Z], but that also seems broken from a UI perspective...

Link in case you want to see for yourself

backroomwebdesign.com/pnks/index.php?option=com_content&view=article&id=36&Itemid=48

Thoughts?
The administrator has disabled public write access.
 
#14998
Re:Best practice with large database (help!) 12 Years, 11 Months ago Karma: 748
Hello,

The module doesn't support paging on server side. We will add AJAX support in a future release. Currently the possible solution split table into several tables that decrease amount of data.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#15000
Re:Best practice with large database (help!) 12 Years, 11 Months ago Karma: 0
Tease. (i kid...) Any ETA on that feature so I can throw some money at you? I really like this module.
The administrator has disabled public write access.
 
#15006
Re:Best practice with large database (help!) 12 Years, 11 Months ago Karma: 748
It takes about a month.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#16384
Re:Best practice with large database (help!) 12 Years, 10 Months ago Karma: 0
Howdy,

Its been about a month, any progress?
The administrator has disabled public write access.
 
Go to topPage: 1