| # |
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: |
| # |
Jul 17th 2017, 09:53 |
jippi |
bownty does around 2-5k req/min |
| # |
Jul 17th 2017, 09:51 |
dakota |
per minute, but I like the per microsecond one |
| # |
Jul 17th 2017, 09:50 |
dakota |
lol |
| # |
Jul 17th 2017, 09:50 |
JD-Robbs |
;) |
| # |
Jul 17th 2017, 09:50 |
JD-Robbs |
Per microsecond |
| # |
Jul 17th 2017, 09:50 |
neon1024 |
@dakota Depends on what a ‘pm’ is |
| # |
Jul 17th 2017, 09:49 |
JD-Robbs |
A month... |
| # |
Jul 17th 2017, 09:49 |
JD-Robbs |
My site, too. 1k visits... |
| # |
Jul 17th 2017, 09:49 |
dakota |
We’re doing 300pm front-end, and 600pm background right now. Suppose that doesn’t count as high traffic :) |