network profile
| bio | website | |
|---|---|---|
| location | Glasgow, United Kingdom | |
| age | 34 | |
| visits | member for | 2 years |
| seen | Jan 28 at 17:32 | |
| stats | profile views | 4 |
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.
|
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 |
