Hi,
pizza392:
hello, i have ceon mod installed, its amazing, i never thought the seo mod could be customized like this.
Thanks for the nice comments, that makes all the time spent developing and supporting it feel that bit more worthwhile! :)
pizza392:
i have a question, will mysql performance issues occur if the store has too many products? i'm so worried about the database issue
Versions up to 3.6.2 had serious performance problems with stores with 10s of thousands of products however version 3.6.3 and 3.8.0 both have query optimisations in them which dramatically improved the performance for large stores.
The store these improvements were made for and tested on has 26,000 products and they have been happy with the results.
Obviously I can't say for sure how it would affect your particular store, as servers differ as do the effects of having a differing number of products.
Realistically I don't see how it could be sped up all that much more, as there is really only a single query necessary to match an exact URI and it is the one that needed optimising previously.
There may be opportunities to further enhance the speed of the software by adjusting the code and any subsequent language check queries etc. but no-one has complained about/mentioned the speed since the changes in 3.6.3 so I can only think of that as a positive sign.
4.0.0 is in development and if issues were to be found with extremely large stores I'd be willing to see what could be done for 4.2.0 to optimise the software further as after 4.0.0 the software should be feature complete and bug free (nothing left to work on except possibly speed, if considered worthwhile bothering).
We're closing up for the weekend now so apologies for not being able to reply further until next week.
Have a nice weekend.
All the best...
Conor
ceon
NOTE: We are sorry that Conor is no longer with us.
We are grateful for all his contributions to the Zen Cart community.