152 reputation
5
bio website minecraft.codeemo.com
location phoenix
age
visits member for 2 years, 5 months
seen 2 days ago

Jan
23
awarded  Popular Question
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?