network profile
| bio | website | highlycohesive.net |
|---|---|---|
| location | Georgia | |
| age | 34 | |
| visits | member for | 2 years, 4 months |
| seen | Jul 15 '11 at 13:59 | |
| stats | profile views | 5 |
Personally I find StackOverflow to be good for personal development. We should all spend some time trying to debug without a compiler. It's also good to challenge and debate methods. "Best Practice" isn't an answer to anything except perhaps "how do I code with the least effort, analysis, and thought possible?"
|
Apr 5 |
awarded | Popular Question |
|
Jul 15 |
accepted | Add DEFAULT to existing column |
|
Jul 14 |
awarded | Critic |
|
Jul 14 |
asked | Add DEFAULT to existing column |
|
Jan 28 |
awarded | Scholar |
|
Jan 28 |
accepted | What's the best way to track Updated By, Updated On |
|
Jan 27 |
answered | How to dive into an ugly database? |
|
Jan 26 |
awarded | Student |
|
Jan 26 |
comment |
Estimate large database size and speed "go try it" is effectively the same as "I don't know." -- Ah, no. "Go try it" is me telling him to not rely on internet opinions for something like determining if there's a performance issue with a given dataset, database, and server. No way am I going to write an entire app just trusting that someone has had an experience that worked fine. Things like server size, data distribution, other databases on the same server, etc. matter. |
|
Jan 26 |
awarded | Teacher |
|
Jan 26 |
comment |
MySQL data type for 128 bit integers I can't help but notice this is the second question where it looks like you're having to do weird things with your solution in order to be able to use MySql. Have you considered a more robust DB platform? |
|
Jan 26 |
comment |
Estimate large database size and speed Granted, it doesn't just answer the question -- but there's really no other way to know for sure when it comes to things like "will this run well" than to do a little proof of concept evaluation. |
|
Jan 26 |
answered | Estimate large database size and speed |
|
Jan 26 |
comment |
What is a Clustered Index? I hear what you're saying. The problem is not with your answer per-se, but in the fact that less experienced people than yourself run around quoting and applying something because it's "best practice" without understanding the use and context the best practice was written for -- I'd argue that yes, we're here to educate and that quoting best practice without providing more context directly in the post doesn't do as good of a job of that. |
|
Jan 26 |
comment |
What is a Clustered Index? I didn't say faster. A covering index has all the data requested in the select in the index - IN ORDER, on a separate location on the disk. So a select against a matching covering index never hits the table. |
|
Jan 26 |
awarded | Autobiographer |
|
Jan 26 |
asked | What's the best way to track Updated By, Updated On |
|
Jan 26 |
comment |
What is a Clustered Index? Non clustered indexes can be just as efficient for lookups, if the non-clustered index is covering for the lookup in question. |
|
Jan 26 |
comment |
What is a Clustered Index? And there in lie the problem with applying "best practice" without context. For instance, if the primary search criteria for a large frequently searched table is a date range, your best location for the clustered index is the date being searched NOT the primary key. To say the table and the clustered index are one and the same is a bit too oversimplified. The data is actually stored in the order dictated by the clustered index. Among other things, this means that clustered indexes are particularly useful for range searches returning the full data set. |
|
Jan 26 |
awarded | Supporter |
