226 reputation
13
bio website
location
age 36
visits member for 3 years, 7 months
seen Feb 26 '13 at 16:09

Oct
7
comment Is there an efficient way to align degenerate strings?
With s1:xcax and s2 of length 5, I wouldn't think that could match. Unless you are trying to find s1 inside of s2? In which case I wrote about the opposite, finding s2 inside of s1.
May
24
comment What's the best way to cache a growing database table for html generation?
I'm not dead set on using a cache. I'm also willing to accept answers that involve using frameworks that have already solved these issues. If/when I get to the point where I need something, I want to know what some good options are. I'm also interesting in learning where the line is to start looking at optimization.
May
23
comment What's the best way to cache a growing database table for html generation?
I was planning on serving the data as json and as an html table. My thought was to process the results and cache the json and html in separate cache keys. The database will be doing a lot of other tasks, so I thought I'd try and keep web server off of it whenever possible. I don't have stats yet, so this is premature optimization. Please don't say "don't optimize prematurely." I'm looking for answers that come from actual experience with a similar volume, not the correct answer for my scenario.
May
23
comment What's the best way to cache a growing database table for html generation?
I incorrectly specified the volume and edited the question to reflect that. 1 per hour is for a specific key, the table grows much faster.
May
23
comment What's the best way to cache a growing database table for html generation?
and for page 2?