1,070 reputation
415
bio website
location
age
visits member for 2 years, 4 months
seen 7 hours ago

May
31
revised What is the advantage of using numeric primary keys in a relational database?
added 274 characters in body
May
31
answered What is the advantage of using numeric primary keys in a relational database?
May
13
comment What is meant by DDBB?
That is, it seems to be used as synonym for "database": bit.ly/1mlbSYJ bit.ly/1sIaNwd bit.ly/1oo62Z1 bit.ly/1gyUmuI One commonality is that those using the term do not seem to be native English speakers, so perhaps DDBB is used in one or more other languages.
May
13
comment What is meant by DDBB?
I understand the criticism, but I think @ddaniel is correct. I had never seen this term before, but in searching on it, everywhere it shows up in the context of databases, it seems to be used as synonym for DDBB. stackoverflow.com/questions/4603215/600-tables-in-ddbb
May
9
comment Host is not allowed to connect to MySQL
You need to make sure the combination of your user, password, and host (which ought to be localhost, per @Seti) somehow gets into the mysql grant tables. Whether that is accomplished through a control panel, or by submitting a request to the hosting provider, is something we can't answer for you. You need to contact your host. See dev.mysql.com/doc/refman/5.6/en/grant-table-structure.html to see how the MySQL privilege system works.
May
8
comment Host is not allowed to connect to MySQL
You say that the username and password in your code are "absolutely and precisely 100% correct". Where did you specify them for the mysql server? Did you have someone at the hosting company add them, or do you have a control panel of some sort so that you can add them yourself?
May
6
comment How to speed up looped INSERT INTO statements?
You need to replace this RBAR approach with a set-based solution if you can--you're doing 10,000 individual inserts, and that's going to cost you. What's in the cursor?
May
5
answered How to retrieve time in XML
Apr
24
answered UK Addresses in 3NF
Apr
23
awarded  Yearling
Apr
21
revised Boyce-Codd Normal Form
added 19 characters in body
Apr
21
answered Boyce-Codd Normal Form
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?