search

Letractively / fuuka

Automatically exported from code.google.com/p/fuuka
Other
0 stars 0 forks source link

Get rid of _local tables #77

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
They're a performance hack, but Foolz codebase shows that you can get good 
performance without them. Apparently.

1. Steal their SQL queries
2. Verify they perform as expected
3. ????
4. this dumb meme literally has something like, 10 years now

Original issue reported on code.google.com by eksopl on 9 Feb 2012 at 3:49

GoogleCodeExporter commented 8 years ago 
Successfully stole Foolz's SQL query for ghost mode sorting from here. Thanks, 
guys.
https://github.com/FoOlRulez/FoOlFuuka/blob/master/application/models/post.php

Couple of points about it, though:
- It's wrong to rely on doc_id to sort posts by date. The doc_id of an earlier 
post is not guaranteed to be smaller than a post made at a later date for data 
in the database before Sphinx was introduced. Using timestamp instead.
- Because of the NULL crap stuff in r98, an extra "OR email is NULL" condition 
is needed. I wish I hadn't made a change like that so lightheartedly, but I 
really needed for media to be NULL in order to fix the regression that 
introduced breakage of images on file deletion. Some reports are going to need 
fixing because of that now, too.

Original comment by eksopl on 11 Feb 2012 at 6:01