Release Trade Dangerous (Est. 2015) Power user's highly configurable trade optimizer

Thanks to Will, we got it fixed.

If you encounter a 403 error when doing an import, that means you need to update TD. Again. Ugh. We're done now right? No more surprise bugs needing fixed? ;)
(v10.4.6)
 
Last edited:
I am going to bed. I'll leave the server running on the fallback index (so there is current information) and let you worry about the surprise bug (reopened latest on git). In fairness, I've had a look and I can't see what's wrong with the logic - then again I've been fighting with A/V codecs most of the night and trying to read SHIPS_URL multiple times between yawns I'm unlikely to spot anything not blindingly obvious.
 
Well, see GIT, the error only appears when calling TD from listener. In any event, index.json is up to date on the server and it's not going to radically upset the apple cart not being able to grab a new copy for a good while. If you still can't reproduce when calling from listener, post to git, no point cluttering up this thread (and maybe worrying people).

Short Answer: Server is currently up, available and providing accurate data.
 
Greetings one and all. Finally after much work at home I have reduced my to do list to a more manageable size and can play Elite again as well as work (occasionally) on TD Helper.

To that end version 3.0.0.1 has just been released and may be found at https://github.com/MarkAusten/TDHelper/releases/tag/v3.0.0.1 and, as usual, you should read the release notes first.

I have carried out some basic testing on this but since it is the Trade Dangerous pip install that has been added but no additional functionality, it should work pretty much as the later v2 release.

There are still some timing issues, especially when selecting a source station for the first time but that seems to be a SQLite issue rather than a code issue. However I'll keep on trying to sort these out if possible.

Thanks.

[Edit] v3.0.0.2 available at https://github.com/MarkAusten/TDHelper/releases/tag/v3.0.0.2
 
Last edited:
Hints & Tips

If you find that updating the Trade Dangerous database is talking a long time, twice or more the time it takes normally, then use the TD clean option to rebuilt the database from scratch. Reduced the update time from around 65 minutes to about 7 on my games PC.
 
Yeah, I've done everything I can think of to speed things up, but apparently in SQLite3 adding new data will always be much slower than editing existing, so when the DB hasn't been updated in more than a few days, it can be better to erase everything and redo rather than updating the existing.
 
apparently in SQLite3 adding new data will always be much slower than editing existing
eyeonus you need more sleep, you're not on the ball. You meant to say adding is quicker than editing.

As an aside, when TD does an update, does it write the whole row? Would it be quicker to update only the changed columns?
 
eyeonus you need more sleep, you're not on the ball. You meant to say adding is quicker than editing.

As an aside, when TD does an update, does it write the whole row? Would it be quicker to update only the changed columns?
I'm fairly certain that an UPDATE takes the same amount of time whether it's only updating 1 column or 100 columns in a row, but I'm no expert.

When doing the listings, though, it doesn't update at all. If it encounters a market that has a newer update, it removes the whole market from the DB and then inserts the new market data. It would actually be even faster to make a blank temp. table, copy all the data that's not about to be removed altogether or replaced by newer data, drop the original table, make the temp table the new original table, and then add in the new data, but that's a lot of code changes.
 
I hid something in this thread, if anyone wants to find it.

It's something I'm working on. If you're interested in helping, github.

It still doesn't actually do anything useful, but progress is being made. Check it out.
 
Last edited:
Top Bottom