Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
donuts236728yHow 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? -
dayo30458yJust finished importing data to new table 440m rows total queries now execute in 0.01s rather then 15-17s
-
Techdaan3168y@dayo Very nice improvement. Well done handling such amounts of data. Which database software are you running? Mariasql, mysql..
-
dayo30458yMySQL 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
-
dayo30458yChecking other tables and half are missing their PKs but have indexes only one has transactional data
Checking database table with 100m+ transactions ... no indexes or primary key :/
undefined