123 reputation
4
bio website
location Glasgow, United Kingdom
age 36
visits member for 3 years, 7 months
seen Jun 18 at 15:10

I'm a programmer living and working in Glasgow, Scotland.

Day-to-day, I work with Java, SQL, some JEE technologies, like JPA, and Javascript.

I'm passionate about performance, and really interested in highly-scalable web applications. I enjoy working with legacy code (Crazy, I know!) because of its trove of interesting challenges.


Jun
6
awarded  Popular Question
May
13
comment Indexing to improve performance of range queries
I misspoke. I should say that the table will be ~ 50000 rows, but the IN list will be ~ 3-4000 items. Sorry :). Does that change things?
May
12
comment Indexing to improve performance of range queries
You're right, large is subjective. Probably ~ 50000 rows.
May
12
awarded  Scholar
May
12
comment Indexing to improve performance of range queries
Cool, thanks. It's likely that the list will be quite large so I'll probably end up throwing on the index. Would it be better to index only created, or do a multicolumn index on (foo_id, created)?
May
12
accepted Indexing to improve performance of range queries
May
12
awarded  Student
May
12
asked Indexing to improve performance of range queries
May
12
awarded  Autobiographer