2,649 reputation
614
bio website
location
age
visits member for 2 years, 10 months
seen Dec 15 at 18:55

Dec
9
comment Database structure for users, events and event lists
@user664303: That depends on your database. Most databases will automatically create an index on your primary key. If you know that most of your queries will also reference both user_id AND event_id, you might want to create an index that contains both columns. You could also probably create two separate indicies, one for each column. Your best bet might be to populate the table with test data, run your queries and analyze the performance and query plans to determine the best way to create indices.
Dec
9
answered Database structure for users, events and event lists
Nov
13
revised Autoincrement Primary Key For Constants
added 24 characters in body
Nov
13
revised Need help designing a database
edited body
Nov
11
answered Design: Fitting variable hierarchy of text files into a relational db
Oct
31
comment Using Case in SQL
This looks suspicious: SUM(CASE WHEN financialinst.name <> 'National Financial Services'THEN Asset.Value END) What happens when the WHEN condition fails? Will SUM work ok on NULL values? Because I'm pretty sure that NULL<>0...
Oct
31
comment Using Case in SQL
What syntax error are you getting?
Oct
31
reviewed Approve Using Case in SQL
Oct
23
comment No-SQL Database Design for restaurant app
Do you have some understanding of how your NoSQL database works? What have you come up with so far?
Oct
7
comment Help in designing mysql table for large project
There's good arguments for your first solution (called a "multi-tenant" database) and your third solution. It's hard to know exactly what is better withouth knowing your requirements better.
Oct
7
revised Help in designing mysql table for large project
formatting
Sep
30
awarded  Explainer
Sep
11
reviewed Approve DB2 - how to safely blow away database on linux?
Aug
5
answered Creating a table with many optional fields
Aug
5
comment Database design for a table with both bulk insert and single row insert
@Munchi: Agreed, Oracle SQLLoader might be an excellent choice. Got any links with hard numbers on how it compares to bulk inserts?
Aug
1
answered Give every user 3 default 'bookmark' entries
Jul
16
comment How to model when you could have many (thousands of) attributes to a table (product)?
@ToC: What do the other dependencies look like? What, exactly, are you having trouble with? Entity-Attribute-Value systems are not new, but they can be tricky to work with. Is there a specific problem that you're having difficulties with?
Jul
16
revised How to INNER JOIN and OUTER JOIN within the same table?
added 51 characters in body
Jul
16
comment Stored Procedure slow after weekend
That sounds like how I feel on a Monday before I've had a chance to get some coffe! ;) ...seriously though, it sounds like some data might be cached but gets dropped from the cache over the weekend, maybe to make room for something else?
Jul
16
comment How to model when you could have many (thousands of) attributes to a table (product)?
@Colin'tHart: Perhaps you could write a full answer with a better solution. ;)