Ever noticed how it could take a couple of seconds for a LEX download to start? Well, not anymore. Over the past couple of days I have been improving the efficiency of all things related to our largest database table, the "Download History". It holds about 15 million download records, and that was beginning to put a serious strain on performance. Things like downloading a file, accessing the dependency tracker, downloading a bulk dependency, etc. took quite some time.
Now, downloading a file is instant, and accessing even the largest (eg. CAM Residential Starter Pack) dependency trackers takes no more than half a second. (Power) searching and the Lot Table functionality are also faster now

On top of that, the Bulk Dependency creation has been rewritten from scratch to be more performant and also more helpful. It will now automatically include cascading dependencies (dependencies of the dependencies) and come with a CONTAINS and WARNINGS file, with a list of all files that were included (including the reason why) and a list of files that couldn't be included (locked/deleted), respectively. Because of the way it is now implemented, there's a chance you may have to re-enter your LEX username/password once every so often when doing a bulk download (browser limitations).
Format of CONTAINS.json[
{
"id": 119,
"name": "BMD Mediterranean Style Farms",
"status": {
"ok": true,
"deleted": false,
"superseded": false,
"superseded_by": -1,
"locked": false
},
"file": "BMD Med style Farms and fields.zip",
"reason": {
"first_time": true,
"outdated": false,
"version_mismatch": false
}
},
{
"id": 345,
"name": "BSC MEGA Props MBEAR Vol01",
"status": {
"ok": true,
"deleted": false,
"superseded": false,
"superseded_by": -1,
"locked": false
},
"file": "Install_BSC_MEGA_Props_MBEAR_Vol01.zip",
"reason": {
"first_time": true,
"outdated": false,
"version_mismatch": false
}
},
{
"id": 403,
"name": "BSC MEGA Props - swi21 Vol01",
"status": {
"ok": true,
"deleted": false,
"superseded": false,
"superseded_by": -1,
"locked": false
},
"file": "Install_BSC_MEGA_Props_swi21_Vol01.zip",
"reason": {
"first_time": false,
"outdated": true,
"version_mismatch": false
}
}
]
Kesher Council Chambers_dependencies.zip contents
If you notice any irregularities, let me know. For those wondering, the bulk dependency functionality can also be triggered with the LEX API v4, using the endpoint
http://www.sc4devotion.com/csxlex/api/v4/lot/<lotid>/bulk-dependency.