317 reputation
17
bio website
location Barcelona, Spain
age 34
visits member for 3 years, 2 months
seen Oct 10 '13 at 8:17

May
31
comment Migrating and normalizing data
Oh, I do use surrogates in the new app. I thought I'd use new ones. But that's probably not very useful...
Dec
28
comment MySQL Sharding tables/servers or other methods to reduce table sizes?
You rarely have control over caching (IIRC, Oracle has this using keep/recycle pools), and I don't think you'll need it- if you have proper indexes, caching will work just fine. If you only do queries with exact matches on two columns, an index for each column will likely yield excellent performance. In any case, I suggest you build a test server (a 4Gb box should be pretty cheap), create a load test (this should be easy given your usage patterns) and try different indexing and configuration options and measure improvements to your load test.
Dec
28
comment PostgreSQL query with max and min date plus associated id per row
Don't worry! I'd suggest you go with Erwin's answer, and only go this way if somehow Erwin's answer can't be made to run as fast as you need
Dec
27
comment PostgreSQL query with max and min date plus associated id per row
Are they? I thought each RDBMS used different syntax. If it is, it boggles my mind that limit/offset is not standardized (which it wasn't last time I checked, IIRC- although that was ages ago).
Dec
27
comment PostgreSQL query with max and min date plus associated id per row
I've upvoted yours. I propose this solution and keep it here 'cause window functions are not widely available in all RDBMSs, nor standardized, and because they might be less performant. However, I'll edit a bit my answer...
Nov
24
comment Compare Microsoft SQL server performance between virtual and dedicated server
VCPUs are troublesome- some virt platforms show decreased performance with multiple VCPUs (although this might be dated information). Which kind of virtual server are you using? The big problem with performance on most virtual servers is that you are sharing a physical box with other virtual servers and IO and CPU time are shared- some other virtual server might hinder you, depending on how the virtualization has been setup. IO performance between your dedicated and virtual box might be pretty different, too (are both using direct-attached storage? SAN?... etc.).