Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
Well e-commerce and SQL one-liners are usually mutually exclusive. Most e-commerce solutions suck because one thing: EAV. And unless it's a solution designed for a very specific product it will rely heavily on EAV because of the big variation and need of metada to fit every single product in the world. I have never needed to face a problem that needs EAV outside of academic purposes but I know if I do I probably will suck big time.
I recommend you this of a real horror story with metadata-driven software
https://red-gate.com/simple-talk/...
when your code is a mess but everything work out in the end
It changed my life, really. 😁
When you keep getting +1s on a rant you posted a month ago.
Colleague asked me to look at his eCommerce search filtering system as the customer was complaining it was slow taking 5-6 seconds to find results.
Delving into the code deeper, I discovered he was querying the results, sticking them in an array and then sub querying the results looking at all the combinations.
On top of that each sub query looked at the database fields using "DESCRIBE" to then search them each time it found a pair!
The total query count for one page search was 14,512!!!
Why oh Why? One SQL query could of done all that in one go.
I look at other code bits he's done and he's very good in other areas. I just don't get how sometimes a good developer can make such a weird decision? It's almost as if he wanted to make it as complex as possible.
rant
queries
nested
developer
php