Is there a C# open-source search app which scales cheaply?

Posted by domspurling on Stack Overflow See other posts from Stack Overflow or by domspurling
Published on 2010-01-27T12:01:32Z Indexed on 2010/05/16 2:10 UTC
Read the original article Hit count: 347

I need to quickly replace a listings website which has the following characteristics:

  • smallish database (10,000 items, < 1GB)
  • < 10% of the items updated/created/removed daily
  • most common activity is searching the whole dataset, returning 1-1000 items
  • traffic peaks at 1m page impressions per day

Scaling strategy for the existing app has been to separate read-only and read/write activity. Multiple slave databases are used for searching and writes are done to a master, which update the slaves using MS SQL replication.

Since read activity is more common than write, this has proved to be a cheap way to do database load balancing, without true clustering.

I now need to replace the app - are there any C# open-source apps which scale as neatly as this?

© Stack Overflow or respective owner

Related posts about open-source

Related posts about database