nostrademons on TC Slows Hacker News - Start the Arc can't scale rants.

Comment on TC Slows Hacker News - Start the Arc can't scale rants.parent

Django has a shell that automatically loads all model objects. If you've got a decent shared-nothing architecture and point your config to the live DB (bad idea, but for the sake of argument...) that's effectively a REPL for the webserver.

For that matter, you can get the same effect with the MySQL prompt and a shared-nothing PHP architecture.

anewaccountname 18y

>For that matter, you can get the same effect with the MySQL prompt and a shared-nothing PHP architecture.

I see how you could, say, drop a user from the users table using this; but how would you fix a login bug like the one under discussion?

nostrademons 18y

  EXPLAIN SELECT username FROM users WHERE username = $dc_user

Then look at the output, and either

  CREATE INDEX users_username ON users(username)

Or cache the result, or do something else to fix the performance problem...

If you meant "How do you find out it was in the registration check?", that's what the slow query log and query profilers are for...

Comments