network profile
| bio | website | minecraft.codeemo.com |
|---|---|---|
| location | phoenix | |
| age | ||
| visits | member for | 1 year, 3 months |
| seen | 2 days ago | |
| stats | profile views | 5 |
|
Nov 2 |
comment |
Converting ZIP code string to integer in SQL Server This is precisely what I needed--to me, the order-of operations with subqueries seemed clearcut, but the realization that the optimizer takes liberties with those will help me avoid this in the future--thanks again. |
|
Nov 2 |
accepted | Converting ZIP code string to integer in SQL Server |
|
Nov 1 |
asked | Converting ZIP code string to integer in SQL Server |
|
Apr 4 |
comment |
Most efficient (or meaningful) way to index grid-based data Thank you for such a comprehensive answer; I think I shall implement choice #1 (two indices) seeing that I can easily stomach the disk cost of the index and that it will not affect my SELECT performance. That, and the more familiar setup it provides I think makes it a more suitable choice. Thanks! |
|
Apr 4 |
accepted | Most efficient (or meaningful) way to index grid-based data |
|
Apr 4 |
awarded | Editor |
|
Apr 4 |
revised |
Most efficient (or meaningful) way to index grid-based data added 168 characters in body |
|
Apr 4 |
asked | Most efficient (or meaningful) way to index grid-based data |
|
Feb 27 |
comment |
Is there a MySQL maximum database or table count? I greatly appreciate your input--I believe I shall indeed implement a system that can help me find a happy medium between an overdose of either tables or databases as well as a non-arbitrary splitting mechanism to call up the correct table/db. Thanks again! |
|
Feb 27 |
awarded | Supporter |
|
Feb 27 |
awarded | Scholar |
|
Feb 27 |
comment |
Is there a MySQL maximum database or table count? Thank you very much; I greatly appreciate the additional perspectives and gotchas to look out for in this design! |
|
Feb 27 |
accepted | Is there a MySQL maximum database or table count? |
|
Feb 25 |
comment |
Is there a MySQL maximum database or table count? I wish I had a meaningful way to make that sort of split. As is, a given user's data will be processed and saved into four tables. Each of the four tables are relevant to recalling the data, each query only needing one table...but for me to find a medium of 280 databases/500 tables means I need to make an arbitrary separation. But I see what you're saying...perhaps I can find a systematic way of evenly splitting the databases so I needn't waste time searching each database for a table hit. Thanks |
|
Feb 25 |
awarded | Student |
|
Feb 24 |
asked | Is there a MySQL maximum database or table count? |
