Monday, February 23, 2009

Realized I copied the wrong database into eveproduction.orders. The one I was using did not include fields for a UID or TimeStamp. I deleted the database and recreated with the proper fields.

The original database was running for just over 24 hours, here are some numbers from just before it was dropped:
  • Total Orders in Database: 114,836
  • Total Regions Represented: 30
  • Total Items Represented: 1,577
  • Vast majority of items have less than 400 orders in system
  • 8 items have over 700 orders in system
  • 1 item had over 1,000 orders (1,114)

Can't tell the oldest order or how many total orders were imported without the timestamp and UID.

While the new database fills up I will work on the MySQL queries.

No comments:

Post a Comment