2.x - Slow Card Price Updates

Report a MTG Studio bug you have spotted or ask for help

Moderator: gaddlord

2.x - Slow Card Price Updates

Postby texasaggie » Tue Jun 28, 2011 9:08 am

I waited to verify this in 2.1 to see if anything had changed, but it did not. This has been an issue since 2.0 for me. The pricing update (apply to cards) is running very, very slow for me. I suspect it is due to the size of the database that I have (~25,000 rows - ~2.5MB size on disk). This is down from ~65MB after fixing the concatenated comments issue with the Suitcase import and vacuuming the database.

The pricing update from the stores is very quick - under a minute for both.

I started the pricing/card update at around 11:30 last night and at 7:30 this morning, it was about halfway done (~12,000 cards processed). So, to update pricing, I'm looking at around 16+ hours.

The computer is quad core, Win 7, 6GB ram, nothing else to speak of running. Tried it on another computer - laptop with similar specs - and it was the same result.

Gad - am I missing something here?
User avatar
texasaggie
Registered User
Registered User
 
Posts: 79
Joined: Sun May 08, 2011 2:54 pm

Postby gaddlord » Wed Jun 29, 2011 4:42 pm

Can you copy/paste the same forum topic in an email to gaddlord@mtgstudio.com and attach your mtgstudio.collection file.
GET LATEST STABLE http://www.mtgstudio.com/download.aspx
Send feature requests and bugs to gaddlord@mtgstudio.com or vote online.
User avatar
gaddlord
MTG Studio Team
MTG Studio Team
 
Posts: 2957
Joined: Thu Dec 18, 2003 12:01 pm
Location: Europe

Postby texasaggie » Wed Jun 29, 2011 4:51 pm

Sent. Thanks!
User avatar
texasaggie
Registered User
Registered User
 
Posts: 79
Joined: Sun May 08, 2011 2:54 pm

Postby chocbudda » Fri Jul 01, 2011 4:56 pm

Ditto on this one

Also prices for foils aren't coming across?
chocbudda
Registered User
Registered User
 
Posts: 25
Joined: Fri Jul 31, 2009 8:00 pm

Postby gaddlord » Sat Jul 02, 2011 7:47 am

Also prices for foils aren't coming across?

There are not many Foil cards with prices but yet there are some provided by the stores - check Zendkar cards for example from ABU Games.

There are lots of foil cards on sale at eBay. You can check their prices from Online Tools|eBay Sales menu.
GET LATEST STABLE http://www.mtgstudio.com/download.aspx
Send feature requests and bugs to gaddlord@mtgstudio.com or vote online.
User avatar
gaddlord
MTG Studio Team
MTG Studio Team
 
Posts: 2957
Joined: Thu Dec 18, 2003 12:01 pm
Location: Europe

Postby texasaggie » Wed Nov 02, 2011 4:14 pm

Just a long overdue followup, but the pricing updates finally completed for me (>24 hours down to 30 minutes or so). Thanks!
User avatar
texasaggie
Registered User
Registered User
 
Posts: 79
Joined: Sun May 08, 2011 2:54 pm


Return to Bugs (MTG Studio)

Who is online

Users browsing this forum: No registered users and 1 guest

cron