Entries tagged mysql, quora in 2013
Filters: Type: entry × Year: 2013 × mysql × quora × Sorted by date
What are the key insights in mastering SQL queries?
You may find this article useful (despite the list-o-matic name): 10 Easy Steps to a Complete Understanding of SQL—I’ve been using SQL for years but I found that some of the concepts explained there helped firm up my fundamental understanding of how to use it effectively.
[... 64 words]How was FriendFeed’s schema less db faster than pure MySQL?
The principle reason they switched to a schemaless DB was to work around the challenges of having to make schemes changes in MySQL, which can lock the table and take hours if bit days to complete in large tables.
[... 115 words]Is there a maximum number of records one can fetch with a MySQL query?
To my knowledge there is no upper limit—that’s why good database libraries provide abstractions that let you iterate over large queries without loading the entire result set in to memory at once.
[... 54 words]Should I store markdown instead of HTML into database fields?
You should store the exact format that was entered by the user.
[... 95 words]