920 reputation
315
bio website
location
age
visits member for 1 year, 11 months
seen 1 hour ago

Apr
15
revised Clustered composite key high fragmentation and fill factor
Answered additional part of OP's question.
Apr
15
answered Clustered composite key high fragmentation and fill factor
Apr
11
revised What mongodb database layout would fit better
Added clarifying phrase in response to comment.
Apr
11
comment What mongodb database layout would fit better
@ypercube: Very true, that was sloppily written on my part. The source there is a MongoDB engineer, and he must be referring to MongoDB itself. The RDBMS world has had years to work on making joins fast, and has been successful at it.
Apr
9
revised What mongodb database layout would fit better
deleted 5 characters in body
Apr
9
comment What mongodb database layout would fit better
If you're going to downvote an answer, perhaps you could provide a comment as to why. It's helpful for improving answers in the future.
Apr
9
answered What mongodb database layout would fit better
Apr
9
comment What mongodb database layout would fit better
I'm still not clear on what you have in mind by "playlists". Is a playlist just the track listing of an album--the songs on it--or is it a selection of songs from various albums?
Apr
9
comment What mongodb database layout would fit better
Also, ccould you clarify what you mean by "Here I don't know what to do about playlists"? Are you considering storing particular combinations of songs from different albums as though they were albums?
Apr
9
comment What mongodb database layout would fit better
What attributes are you going to record? For example, do you want to store the length of each song on an album? Do you want to store the members of the album's bands?
Apr
8
answered Implementing voting system like reddit/StackExchange?
Mar
31
comment Alphanumeric field in MySQL
"I thought to split the field as 3 different columns" If storing the contract number in three columns is an option, that is the simplest way to do this--one for city code, one for date, and the third auto_increment column.
Mar
28
comment Alphanumeric field in MySQL
Question: Let's say we have one contract with the contract number CBE27032014001. If there is another contract in that city the following day, would the contract number be CBE28032014001 or CBE28032014002? I'm assuming the former.
Mar
27
comment MySQL: Use Sysbench on Windows
I downloaded the tarball and read the README-WIN.txt. It certainly indicates that it can be compiled on Windows using CMake.
Mar
27
comment MySQL: Use Sysbench on Windows
No, I'm not sure. That was actually quite an old article and since then (read the comments) the application has been ported to Windows.
Mar
27
answered MySQL: Use Sysbench on Windows
Mar
25
revised How to use keys in a table so two columns are unique
Answered additional questions per comment.
Mar
25
answered MySQL: SLEEP injection
Mar
25
answered How to use keys in a table so two columns are unique
Mar
11
awarded  Popular Question