11,153 reputation
11842
bio website
location Munich
age
visits member for 3 years, 2 months
seen 6 hours ago

11h
comment MySQL CHAR(500)?
Again: did you do any testing that confirms your assumption? I would very much doubt that you'd be able to measure a difference.
11h
comment MySQL CHAR(500)?
"and VARCHAR is a less efficient storage mechanism" - how do you know that? Did you do any performance testing?
16h
comment DBMS database management system
This question appears to be off-topic because it does not show any research effort
17h
comment Why would SELECT * be magnitudes faster than SELECT foo?
The first statements most probably uses the primary key index on id to find the first row. The second one needs to sort the complete result on the (un indexed) val column.
19h
comment get average of rating using group by and then finally overall rating . Example below
Which DBMS are you using? Postgres? Oracle? DB2?
19h
revised get average of rating using group by and then finally overall rating . Example below
fixed code formatting
1d
comment Search a alphanumeric value from varchar column in DB2
Cross post: stackoverflow.com/q/24969813/330315
1d
comment Auto increment char varying column prefixed with some characters
"can't we just make any varchar as auto-increament" - that is not the correct question. What you are trying to achieve simply doesn't make sense.
1d
comment How to generate the E-R Diagram of Wordpress using mySQL Workbench
Most probably Wordpress isn't using any foreign keys (as so many off-the-shelf products...)
1d
comment Auto increment char varying column prefixed with some characters
Why would you want to do that? If every key value has the prefix PAT there is no sense in storing it. Create a serial column and a view that formats the number as desired. Additionally: the value of a primary key has no meaning whatsoever. You should not care about the values in that column, the only thing you need to care about is that they are unique.
1d
revised Auto increment char varying column prefixed with some characters
deleted 54 characters in body; edited title
2d
revised Inner Join or what else?
edited tags
2d
revised Risk of disabling page locking
edited tags
2d
comment Postgres vs Mongodb, Suggestions to improve mongodb performance
Relational databases have been designed for ages to do efficient aggregation. My understanding is that aggregation (of mass data) is not the sweet spot of NoSQL databases - they are intended and designed for other areas. See for example this blog posting: tapoueh.org/blog/2014/02/…
2d
revised Postgres vs Mongodb, Suggestions to improve mongodb performance
added 75 characters in body
2d
comment Index on 'GROUP BY' with functions
MySQL doesn't support indexes on expressions or functions
2d
revised Index on 'GROUP BY' with functions
edited tags
2d
comment Why is my composite index not used for this table?
Half a millisecond doesn't seem to be slow though...
Jul
23
revised How to avoid the SORT operation in SQL query that contains ORDER_BY condition?
spelling
Jul
22
revised Adding a constant IF not in an other table
added 72 characters in body; edited tags