[RELEASE] Slopey's BPC Market Tool! - New version!

parsing is now extremely slow for me as well..... Much slower than previous versions. :/ 4.2.0.1 version is barely useable for me.....

I loved the old versions so much! but this present release is hardly working. I'll try and do a clean install.
 
I'm aware of it, I've had other things to worry about, but it is on the cards for a fix asap.


Yes, uncheck "auto-updates", quit the BPC. Then delete ED4.db from the BPC directory and copy ED4.backup to ED4.db. Then restart the BPC. That'll keep all your data intact - the BPC always backs-up ED4 when you start it.

Quote Originally Posted by Antk
Updated to 4.2.0.3 , slowest parsing ever.. only 16% after 'round 15min.. Anyway thanks for you work


If you don't need to keep historic data, delete ED4.db and restart it.
Quote Originally Posted by Kozmyk
I've got 4.2.0.3 in but Parsing is running at about 11secs per 1% ... 10 mins or so


As above.

Aah! Well in that case I'll put up with the initial delay if it's busy and not just bogged down.
I'd like the older data to persist if poss.
Prices may vary but source info should still be valid.
 
Did you write the exact station name in the dropdown before you imported the .bpc file? You must write it down manually if it is not already in the dropdown otherwise it will not import any data.
I did. Doublechecked it in fact. No big deal though, I'm over it. :D
 
Hi Slopey,

Found a bug. The "Local Time UTC Offset" seems to be buggy. For instance, when I choose "01:00:00 Paris, Madrid" and click "Ok" the validated offset (visible by coming back in the Options menu) is "02:00:00 Jordan". Similar bug appears by choosing different offset...
 
Forget it, this tool is getting worse by the day. I'm getting a locked message now. Thanks for the effort Slopey, I'll stick to the less populated but more reliable Thrudds.

If Slopey's becomes stable I will consider donating as a thank you.

wouldn't bother (2x £10 donations so far) not even a acknowledgment or a thank you back just total ignorance. wont be donating again his charity's loss not mine (I regulary donate to charity's)
 
Adding distance data?

Slopey,
Thanks for making a great tool.

Regarding distance data.
Noticed that I didn't get any results when I was in 'Shinrarta Dezhra' and had 'Within Distance' selected. Checked table system in the db and there was no data for the system.
How can I add missing system data? I tried to just add it to the table and started BPC again but that seems to do nothing. I see no other data for calculating distance in the db.
 
Hi

I use BPC in combination with EliteOCR (like the most people I think).
So my "Last Updt From" is always up do date, but I have not find a way to filter for it.

There is a "today" filter, but this still gives me data from "11:30", "11:56", "12:23", ... ,"22:03", ...
And all this old data is useless because I added the newest data to the tool.
Its also useless to see in the "Last Updt To" at "22:40" data from "09:21".
It would be nice if we could filter for the last 5, 15, 30, ... minutes, or 1, 2, 3, ... hours.


Is it planed to release BPC under a open source license (maybe only the client)?
This would give us the possibility to create patches (new features, bug fixes, whatever, ...) and send them to Slopey.
Slopey can still decide if he adds them or not.

I'm not the best programmer, but I think a filter should be possible for me ;)

Yogg
 
It was a bit of a blow to see several systems missing that were there before, I manually added them again, like others have suggested, out of date data stays relevant for weeks in my experience, maybe add a check which applies a filter to show/hide out of date data, only removing it after a month, or use two sources and warn that using out of date data will take much longer

Edit also only the last prices really need to be shown for those who care about how much data is shown
 
Last edited:

Slopey

Volunteer Moderator
Slopey,
Thanks for making a great tool.

Regarding distance data.
Noticed that I didn't get any results when I was in 'Shinrarta Dezhra' and had 'Within Distance' selected. Checked table system in the db and there was no data for the system.
How can I add missing system data? I tried to just add it to the table and started BPC again but that seems to do nothing. I see no other data for calculating distance in the db.

Shinrata doesn't have published coordinates from FD, hence it isn't available for a distance search. There's no way to update them currently but I may add something in to a future version. I've heard anecdotal comments that the EDSC data is incorrect for many systems, so I've avoided it for now, but if it's accurate, I'll thing about supporting it sooner rather than later. Before that however, I want to get in outpost landing pad sizes, and distances to stations from the jump point.
 
Great tool indeed, helped a lot improving my profits although I got some nice trade routes before. Especially helped finding special goods. Anyway, with the "return trip" button gone it kinda lost its purpose. I guess this needs to be back asap Slopey. Thanks for great work!
 

Slopey

Volunteer Moderator
It was a bit of a blow to see several systems missing that were there before, I manually added them again, like others have suggested, out of date data stays relevant for weeks in my experience, maybe add a check which applies a filter to show/hide out of date data, only removing it after a month, or use two sources and warn that using out of date data will take much longer

Edit also only the last prices really need to be shown for those who care about how much data is shown

I'll have more data management features in "soon", so you can tidy your data on the fly.

- - - - - Additional Content Posted / Auto Merge - - - - -

wouldn't bother (2x £10 donations so far) not even a acknowledgment or a thank you back just total ignorance. wont be donating again his charity's loss not mine (I regulary donate to charity's)

I only just picked up your PM today NoTones - no need to be rude. As a rule, I don't acknoweldge all the donations via paypal, aside from a few which I did to confirm they were correct. And anyway - you've told me they may not have even come through?!! How can I respond to something I've possibly not received correctly?

All donations are grateful received, and I've said so on many occasions, but I've not had any other people requesting I thank them personally every time.
 
Last edited:
Is there any chance of this working acceptably again? I reinstalled last night and after 3 hours, the tool was only up to 300 systems known. I can't use it if it will take a month to populate the data. o_O

Some serious problem with the network code, it seems.
 

Slopey

Volunteer Moderator
Is there any chance of this working acceptably again? I reinstalled last night and after 3 hours, the tool was only up to 300 systems known. I can't use it if it will take a month to populate the data. o_O

Some serious problem with the network code, it seems.

It has nothing to do with network code. It's actually due to the speed at which SQLite processes a Delete command. I've worked around that now and can parse 72,000 entries in 43 seconds, which is the size of a nomal 48 hour duration update. I'm going to try and optimise it further but that's likely about the best I can do for the moment.

There'll be a new version very soon which takes advantage of the above.
 
It has nothing to do with network code. It's actually due to the speed at which SQLite processes a Delete command. I've worked around that now and can parse 72,000 entries in 43 seconds, which is the size of a nomal 48 hour duration update. I'm going to try and optimise it further but that's likely about the best I can do for the moment.

There'll be a new version very soon which takes advantage of the above.

Interesting! I've not used SQLite before (MySql/PostGRESQL/etc type guy here). (But then again, why on a fresh install would it be doing a bunch of DELETEs? Maybe this is not the problem I'm having?) Either way, will love to see the new version.
 
I still can't use the latest version.

Sometimes it loads, updates the markets then stalls on Parsing.

Other times it just crashes.

For the crashing incidents, I have two files. The first (called Error 01) asked me if I wanted to continue. The second (called error 02) was a fatal crash.

I have tried uninstalling the program and reinstalling, several times.


I will be really grateful for any advice.

View attachment 6939

View attachment 6940

I let the parsing run its course. It took 2 1/2 hours.

logged off then back again. This time
A Table in the Database is Locked.

Is anyone that can suggest a solution I haven't done yet?
 

Slopey

Volunteer Moderator
Interesting! I've not used SQLite before (MySql/PostGRESQL/etc type guy here). (But then again, why on a fresh install would it be doing a bunch of DELETEs? Maybe this is not the problem I'm having?) Either way, will love to see the new version.

Both delete and update are very slow in SQLite. INSERT OR REPLACE is much faster, which is what I'm using now, but it necessitated a new unique key on the database.

If I wasn't bothered about keeping historical data at launch, I could dump the table and insert from scratch in about 35 seconds, but as people want to keep historical data, I've not had that option.

- - - - - Additional Content Posted / Auto Merge - - - - -

I let the parsing run its course. It took 2 1/2 hours.

logged off then back again. This time
A Table in the Database is Locked.

Is anyone that can suggest a solution I haven't done yet?

Delete your ED4.db, and try again. 2 1/2 hours is wierd though, never takes longer than 3mins on my system fora 48 hour data set.. Have you got a load of historical data in it?
 
Hi, I've downloaded & updated the tool but when I launch it crash before anything happens.
Im running w7x64 (w\o speech recognition service but all the rest is up to date), any suggestion ?
Thanks in advance...
 
Both delete and update are very slow in SQLite. INSERT OR REPLACE is much faster, which is what I'm using now, but it necessitated a new unique key on the database.

If I wasn't bothered about keeping historical data at launch, I could dump the table and insert from scratch in about 35 seconds, but as people want to keep historical data, I've not had that option.

- - - - - Additional Content Posted / Auto Merge - - - - -



Delete your ED4.db, and try again. 2 1/2 hours is wierd though, never takes longer than 3mins on my system fora 48 hour data set.. Have you got a load of historical data in it?

Thank you Slopey. Love this program.
 
Back
Top Bottom