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

Jul
23
awarded  Yearling
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.
Oct
7
revised Is there an efficient way to align degenerate strings?
added 360 characters in body
Oct
7
answered Is there an efficient way to align degenerate strings?
Oct
6
revised Storing stop/start points in a database
added 279 characters in body
Oct
6
awarded  Teacher
Oct
6
answered Storing stop/start points in a database
May
24
revised What's the best way to cache a growing database table for html generation?
filling in more detail on the question
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
awarded  Editor
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
revised What's the best way to cache a growing database table for html generation?
added clarity for table row counts
May
23
comment What's the best way to cache a growing database table for html generation?
and for page 2?
May
23
awarded  Student
May
23
asked What's the best way to cache a growing database table for html generation?