# |
Jul 17th 2017, 10:13 |
braeden |
and just hope that what you've got can be tuned, and doesn't need to be completely rewritten |
# |
Jul 17th 2017, 10:12 |
braeden |
I guess the only real way to find out is to deploy and tune as you go |
# |
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. |