Page 1 of 1

Suggestion: optimize sql queries before adding new features

Posted: Tue Aug 28, 2012 4:41 pm
by marcelwoo
First of all, I want to say Daniel is a great coder and opencart is so far the best cart system I have ever used.

I know he keeps developing new features requested by users, which is perfect, but I think maybe he should now stop for a while and look at the current sql queries before he continues.

(1)When I was playing around with opencart, I found in some places, there were a little bit excessive sql queries.
(2)Index not added for some tables.
(3)some queries are not cached even if they should be(like the product url alias queies.).

Yes, I can do it by myself, but what if I need to update to a newer version? It is gonna be a pain to find out all the differences and change. I believe people who heavily modify their carts will face the same problem.

I sincerely hope Daniel could think about this and makes opencart way better!

Re: Suggestion: optimize sql queries before adding new featu

Posted: Tue Aug 28, 2012 4:49 pm
by i2Paq
You could submit your suggestion as new code at the OpenCart GitHub.....

Re: Suggestion: optimize sql queries before adding new featu

Posted: Tue Aug 28, 2012 6:15 pm
by marcelwoo
Oh, sorry for being stupid ;) Yeah, it is a good way for everybody to contribute.