Went another rabbit hole tonight and... decided that the low CPU/one page at a time/not mobile friendly/etc. lists really needed a fresh approach.

It will probably break prototype/scriptaculous -- obsolete since early 2010 -- and force me to replace everything with (at least) jQuery but the user experience should improve quite a bit.

Trying a prototype based on https://datatables.net/ for the collection lists:

Current: static, reload one each page, reload on each search, using &max= also forces a reload, pagination is buggy, iCover display doesn't retain the current sorting, etc.



Prototype: dynamic, everything is retrieved only once, all sorting/search/pagination/row increases are local and fast, iCover displays exactly the list in the same order.



Julien

=> I'll try to backport the code to the current code base on a test page for logged on users this weekend to have more people try/play with it.

Julien

First prototype up!

Not everything is working (default/forced sorting is acting weird, condition or custom date also wrong).
All javascript should have been converted for basic collection functions but proceed carefully as it's hitting the live database.
It should work for both private browsing and public collection links.

You need to be logged and have discs in your collection obviously... or check someone else's public collection.

=> https://www.lddb.com/collection2.php



The screenshot above is https://www.lddb.com/collection2.php?action=list&cat=category&key=30&user=admin

Julien

Fine-tuning further:

• Sorting is better but must still find how to get DATE and CONDITION to sort properly.
• Empty lists were throwing an error => fixed

Don't hesitate to post/send me feedbacks if you find any issue.

Julien

With a lot of code shared between Collections and Wishlists, converting the Wishlists were not too difficult:

=> https://www.lddb.com/wishlist2.php

Julien

Kept playing with this tool for the main search results.

For example, you could look up all the PILF-1* LDs, and then use the advanced search to select Letterboxed, Surround and THX:

https://www.lddb.com/search.php?adv_search=*&adv_reference=PILF-1%2A&picture=2&soundtrack=4&thx=yes



With the new data tables, you can load all PILF-1* in one shot (will take a few seconds), but then you can reorder and filter at will and nearly instantly from your local browser. No more further database access required.

The same search becomes a filter using LBX SRD THX:



Julien