Anybody else having problems with ELR?
EDIT: Let's try this. /u/daath help!
Sorry guys - I was out with the family when it went down. I kicked it back up and am investigating the reason. It looks like it ran out of memory - now I need to find out why :P
Is there an export function in ELR? I need to back up my recipes, but I was hoping I could just pull a copy of them out...I'm lazy.
/u/daath What kinda database / query engine are you running to return search results back so quickly on the database? Or are you just indexing it constantly? I'm assuming it's some type of NoSQL db, but...as an amateur programmer, these types of things fascinate me.
It's actually a rather small database with < 40,000 flavors (almost a third of which have no matching recipes) and < 20,000 recipes. Even without any indexing, things shouldn't be sluggish with any database backend. I'm a MySQL DBA and have had to optimize databases with millions of records....stuff like that is when some clever indexing is really needed.
NoSQL doesn't automatically mean high performance. It works best for write-heavy environments, where traditional relational databases can struggle. ELR, like almost every website large or small, is heavily skewed towards reads, not writes. Non-relational databases also are easier to scale horizontally (adding additional server nodes), but again for most websites, which run only a single or a small number of servers, this isn't an issue. Traditional RBDMS's like MySQL and PostgreSQL are in many cases the better choice for websites.