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

Sep
17
asked Optionally free-form reference
Sep
30
answered Database schema - performance v correctness information
Sep
17
awarded  Yearling
Jun
1
awarded  Scholar
Jun
1
accepted Migrating and normalizing data
May
31
awarded  Student
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...
May
31
asked Migrating and normalizing data
Mar
27
answered Storing Changes To Records
Jan
28
answered I have lots of free memory. How do I use it to increase performance?
Jan
23
awarded  Tumbleweed
Jan
16
asked Working across multiple PostgreSQL database servers
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
answered MySQL Sharding tables/servers or other methods to reduce table sizes?
Dec
28
awarded  Critic
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...
Dec
27
answered PostgreSQL query with max and min date plus associated id per row
Dec
27
awarded  Citizen Patrol