504 karma · joined March 31, 2011
c/c++, embedded c, elixir/erlang. Backend & Software Architect.
https://www.linkedin.com/in/keithbrings/
Elixir https://github.com/noizu/ElixirScaffolding https://github.com/noizu/SimplePool https://github.com/noizu/KitchenSink https://github.com/noizu/RuleEngine https://github.com/noizu/MnesiaVersioning
Php https://github.com/noizu/fragmented-keys https://github.com/noizu/domain-objects https://github.com/noizu/php-conform
Java https://github.com/noizu/fragmented-keys-4java
``` Follow the instructions for preparing responses from the COPILOT.md file in how you answer and format your answer to the following prompt.
<whatever my request was> ```
CB would get frustrating when wanting to extend certain functionality however, which phoenix isn't quite as bad about.
In the past I was the architect of a top 2000 alexa ranked social networking site, data synchronization delays were insane under certain load patterns high single low double digit second write propagation delays.
This tends to be beneficial regardless of the root cause.
edit this is especially useful for handling search/query misses as a query with no results is going to scan any relevant indexes etc. until it is clear no match exists meaning a no results query may take up more cycles than a hit.
At a certain point in time, not that we've reached it, it starts to look like the ptolemaic system, or luminiferous aether, where you keep tacking on exceptions or explanations to fit the data to your model instead of your model to the data.
I generally have layers of caching on top of the sql server so the majority of queries will be integer equivalency or range checks, if not get by primary key queries. So I am not generally operating in a scenario where a stored procedure would reduce record scans, etc.
I generally also don't run on transactions out side of limited scenarios, since throughput is usually more important to me than data consistency.