oakleaf Posted January 16, 2004 Share Posted January 16, 2004 Hi all. I have nearly finished my site selling containerised plants wholesale in France, with the exception of adding the thumbnails for the plants. However, I have two problems: 1: The database is just too damn slow. I used Easypopulate to up all the articles (I have approximately 5000) using the categories. It still takes ages to sort each page out. I have tried checking other posts on increasing the speed of the database but have not seemed to have had much sucsess. I am running the database on MYSQL on my webserver. 2: I have not loaded any articles into the English categories, as I use only french, but my site seems to want to flip back occasionally to english, and consequently shows no content. You enter through a link on my front page ("Catalog") which specifies "...?language=fr" and this works as it kicks you into french from the start and the site gives you no option to change, but I have noticed at certain times a "page back" click results in a language change. A permanent fix making fr the definitive default using no UK at all would be good. Lastly, any other constructive comments pertaining to ease of navigation, logic of layout, (criticism, advice....anything) will be warmly appreciated. My thanks to you all. And congratulations on the excellent resource that this forum provides. As a total novice, I would never have got this far. It has been invaluable to me at every step. Kind regards. James Link to comment Share on other sites More sharing options...
mtimdog Posted January 16, 2004 Share Posted January 16, 2004 1. If it's your webserver, are there any other processes/applications that you can stop to make it run faster? Also, you could **try** persistent connections and/or increase your total # of mysql connections allowed. 2. What version of Oscommerce are you using? I have MS2 and can set the default language for the entire store using the admin panel. Link to comment Share on other sites More sharing options...
1quicksi Posted January 16, 2004 Share Posted January 16, 2004 There are lots of tweaks you can make to MySQL to make it run smoother. Best bet beleive it or not would be to visit VBulletin's forums and look at the way they recommend to tweak MySQL. Also are you sure it is MySQL and not the server itself? How much memory are you reserving for php? Do you have command line access? If so run "top" to see what services are taking up the most processor resources. Also what are the percentages of use per processor? What is the available cache vs swap space? knowledge base | Contributions | Search Link to comment Share on other sites More sharing options...
oakleaf Posted January 23, 2004 Author Share Posted January 23, 2004 I'm running mysql on my hosting server (jumpline) and my access is using mysql. Could it be simply this? Do i have to have it on my own servers for it to work at a resonable pace??? Or is it really something in the way i have created the database? Thanks for your replies. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.