129 reputation
7
bio website jmglov.net
location Stockholm, Sweden
age 35
visits member for 3 years, 9 months
seen Sep 15 at 11:45

I am a grumpy systems programmer who has been forced to use high-level languages by the Evil Forces of Capitalism. I live in Stockholm, where the definition of great weather is: not currently -25 C. I enjoy innebandy, glög, and solglasögon.


Apr
22
comment Do InnoDB or MyISAM tables offer better insert performance in MySQL 5.1?
Very cool! Thanks.
Mar
15
comment Is it possible to trace the delegation path for a DNS lookup?
That works a charm!
Feb
23
comment Is it faster to create indexes before or after data loading in MySQL?
I ended up going with LOAD DATA INFILE, which is substantially faster than any other loading tricks I've tried.
Feb
23
comment Is it faster to create indexes before or after data loading in MySQL?
Good call. Luckily, I'm creating all indexes after loading the table, so I get to not worry about disabling the. :)
Feb
17
comment Do InnoDB or MyISAM tables offer better insert performance in MySQL 5.1?
I ran a test which took 30 minutes with InnoDB, but only 6 with MyISAM!
Feb
17
comment Do InnoDB or MyISAM tables offer better insert performance in MySQL 5.1?
Thanks for the tip on LOAD DATA INFILE. I think I can actually use it for my application. That combined with MyISAM should speed my process up quite a bit.
Feb
16
comment Is it faster to create indexes before or after data loading in MySQL?
Thanks for the pointer; some of those tips look quite promising!