| # |
Jul 17th 2017, 10:12 |
inoas |
meh |
| # |
Jul 17th 2017, 10:12 |
inoas |
however by id means the target table has to fetch the unique published iterm within the revision group ... or the last created |
| # |
Jul 17th 2017, 10:11 |
inoas |
but really by revision_id would be enough, "too" |
| # |
Jul 17th 2017, 10:11 |
inoas |
aka say a document can link to a tag just by its "id" or also by it's revision_id |
| # |
Jul 17th 2017, 10:11 |
inoas |
I have hybrid associations and they suck a lot |
| # |
Jul 17th 2017, 10:11 |
inoas |
just better names |
| # |
Jul 17th 2017, 10:11 |
inoas |
yes for my current app I feel like that but I couldn't really find a better way |
| # |
Jul 17th 2017, 10:10 |
 braeden |
because things can get messy real fast if the schema isn't up to scratch |
| # |
Jul 17th 2017, 10:10 |
inoas |
so figure out how to use ETags and stuff like that |
| # |
Jul 17th 2017, 10:10 |
braeden |
but something as fundamental as the database schema shouldn't be overlooked |
| # |
Jul 17th 2017, 10:10 |
inoas |
for GET |
| # |
Jul 17th 2017, 10:10 |
inoas |
you can also cache HTTP queries on a front proxy |
| # |
Jul 17th 2017, 10:10 |
braeden |
I think I worry too much about what is the correct way to approach things, instead of just diving in and getting stuff done |
| # |
Jul 17th 2017, 10:10 |
inoas |
good schema + good queries :) |
| # |
Jul 17th 2017, 10:10 |
inoas |
but I would not worry about memcached "too much" |
| # |
Jul 17th 2017, 10:09 |
inoas |
I think it is worth a lot to invest time into a good schema |
| # |
Jul 17th 2017, 10:09 |
inoas |
I don't think it really is ;p |
| # |
Jul 17th 2017, 10:09 |
braeden |
Flashback to 2007 |
| # |
Jul 17th 2017, 10:09 |
braeden |
ImageShack is still around? crikey |
| # |
Jul 17th 2017, 10:09 |
inoas |
LOL |
| # |
Jul 17th 2017, 10:09 |
inoas |
and then ship it ;p |
| # |
Jul 17th 2017, 10:08 |
braeden |
that's if I ever get to the shipping stage |
| # |
Jul 17th 2017, 10:08 |
inoas |
LOL |
| # |
Jul 17th 2017, 10:08 |
inoas |
and then ship it ;p |
| # |
Jul 17th 2017, 10:08 |
braeden |
ha! |
| # |
Jul 17th 2017, 10:08 |
inoas |
and then ship it ;p |
| # |
Jul 17th 2017, 10:08 |
inoas |
I'd optimize on the DB first... indexes - maybe sql views can be optimized better than pure joins (take a look), and then make sure you build good queries |
| # |
Jul 17th 2017, 10:08 |
braeden |
and some view cells which re-appear often |
| # |
Jul 17th 2017, 10:07 |
braeden |
common DB queries |
| # |
Jul 17th 2017, 10:07 |
inoas |
caching what exactly? get files? |
| # |
Jul 17th 2017, 10:07 |
braeden |
I've changed the database schema a few times now, normalising, denormalising... maybe I should stop worring |
| # |
Jul 17th 2017, 10:07 |
braeden |
I'd prefer to do things "right" the first time, but unfortunately it's just dragging on development |
| # |
Jul 17th 2017, 10:06 |
braeden |
because better safe than sorry, although I am hopelessly optimistic |
| # |
Jul 17th 2017, 10:06 |
braeden |
I'm building my site around memcached. |
| # |
Jul 17th 2017, 09:55 |
inoas |
in 3-4 years we had issues only twice... once due to recursive and once due to affiliate-click-bait-spamming and request-actions + sql queries |
| # |
Jul 17th 2017, 09:54 |
inoas |
but thats cakephp2 anyway |
| # |
Jul 17th 2017, 09:53 |
jippi |
and around 150k taks/min in cli |
| # |
Jul 17th 2017, 09:53 |
inoas |
with request actions and recursive > -1 we have problems ;) |
| # |
Jul 17th 2017, 09:53 |
JD-Robbs |
That'd be * 60,000,000. |
| # |
Jul 17th 2017, 09:53 |
inoas |
without request actions or recursive > -1 there is no problem |
| # |
Jul 17th 2017, 09:53 |
neon1024 |
Our most popular site gets about 2.3k visitors a day :slightly_smiling_face: |