24
dayo
8y

Checking database table with 100m+ transactions ... no indexes or primary key :/

Comments
  • 0
    How would anyone be able to use it? Just records it and hopes no one ever needs to look this up?

    Pretty useless waste of space?
  • 0
    Sounds like hell on earth. Have fun.
  • 2
    Just finished importing data to new table 440m rows total queries now execute in 0.01s rather then 15-17s
  • 0
    @dayo Very nice improvement. Well done handling such amounts of data. Which database software are you running? Mariasql, mysql..
  • 0
    MySQL currently writing a consolidation programme as there are several of these tables, if I don't start consolidating now I'm just gona run into headaches later
  • 0
    Good idea to fix it asap
    Gl man.
  • 0
    Checking other tables and half are missing their PKs but have indexes only one has transactional data
Add Comment