267 reputation
37
bio website cubrid.org
location Seoul, South Korea
age 27
visits member for 3 years, 9 months
seen Aug 27 at 8:02

I'm a developer at NAVER Korean IT Corporation. I used to be a project manager of CUBRID open source database. Now dedicate my full time to Node.js development. At NAVER I develop a real-time distributed log search system which uses ElasticSearch, Kafka, Storm, CUBRID, Redis, and Node.js. I also maintain Pulsr, a fast Node.js Web Framework, in my personal time. See my Github for other modules I have created.


Mar
21
revised In MySQL, does the order of the columns in a WHERE clause affect query performance?
reflected the suggestions made by other users in the comments.
Mar
21
comment In MySQL, does the order of the columns in a WHERE clause affect query performance?
Right, I agree. However, this is valid in case the value selectivity is low. Considering the data type that Patrick (this question author) uses, which is DATETIME, indexing is recommended. Usually this type of field has quite large set of values, unless there is an odd situation when he uses only several possible dates. *I will edit my answer above to make more clear and valid statement.
Mar
18
answered In MySQL, does the order of the columns in a WHERE clause affect query performance?
Mar
17
awarded  Supporter
Mar
16
comment Storing IP address
nhnb, IPv6 is 128 bit, but the conversation is about IPv4 which IS 32 bit. No need to comment on each comment/answer insisting on your knowledge.
Mar
15
revised Storing IP address
added MySQL syntax
Mar
15
awarded  Editor
Mar
15
revised Storing IP address
added memory size
Mar
14
awarded  Teacher
Mar
14
answered Storing IP address