103 reputation
4
bio website totalgood.com
location Kota Kinbalu, Malaysia
age
visits member for 2 years, 4 months
seen Aug 14 at 21:34

Former robotics engineer converted to web developer and opensource contributor--mostly in Python and PHP. I enjoy automating drudgery and augmenting human decision-making with software.


Sep
24
awarded  Autobiographer
Mar
20
comment Character vs Integer primary keys
Thanks. Your question forced me to look at this question more thoroughly than I had in the past (I used to do this your way), and saved me a lot of scalability and speed grief by doing it the standard way.
Mar
20
answered Character vs Integer primary keys
Mar
20
comment Character vs Integer primary keys
@BrianBallsun-Stanton if you have any bulky sequential data that rels to these lookup tables, storage space is not cheap (in terms of query speed) because disk read speed is the bottleneck in any RDB that can't be cached entirely in RAM. I found this while trying to develop an RDB schema that can compete with the best in the time series DB business Full disclosure, I have no relationship to Skyspark, except that they charge my employer a lot for use of their very efficient DB.
Mar
12
awarded  Excavator
Mar
12
awarded  Editor
Mar
12
revised Performance implications of MySQL VARCHAR sizes
minor typo ("the the"). e.g. filler just for accuracy and to get over the minimum edit-distance threshold
Mar
12
suggested suggested edit on Performance implications of MySQL VARCHAR sizes
Sep
13
awarded  Supporter