h4x0r Posted May 28, 2008 Posted May 28, 2008 Hey guys, been running into a problem on a new host...something is causing excessive use on the mysql server and I'm about to get suspended if I can't get this resolved. I'm a little worried about the indexing of my products and have included a link to a screen shot of my products table from phpmyadmin...I circled in red what I am worried about...should my cardinality for idx_products_date_added be that low? I would have thought it would be the same as PRIMARY. I'm not a mysql genius so I'm not entirely sure if this is correct or not. http://rhino-technologies.com/index.JPG I have already checked and optimized every table in my db...any thoughts or suggestions here would be GREATLY appreciated!
spooks Posted May 30, 2008 Posted May 30, 2008 bump... anyone? thoughts? suggestions? http://www.oscommerce.com/forums/lofiversion/i...hp?t209264.html Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al.
h4x0r Posted May 30, 2008 Author Posted May 30, 2008 http://www.oscommerce.com/forums/lofiversion/i...hp?t209264.html Yes, thank you for that useful, albeit utterly off topic, response. Isn't there be a newb forum you should be trolling? It's just rather presumptuous to lump my thread in with 'help vampires.' Figuring as how I've already searched this forum and google for info on my subject matter, as well as currently looking at the mysql docs so as to better educate myself on the matter, I would say that responses such as yours are a greater detriment to the online community than some of these 'vampires.' Aside from that, I've only bumped this thread once per day. If you have suggestions on a way I could rephrase what I'm asking or ideas on details I have unknowingly left out then I will gladly do my best to include them. Otherwise unless you actually have some way of contributing in a beneficial method, then stop trolling and GTFO of my thread.
spooks Posted May 30, 2008 Posted May 30, 2008 It`s your attitude thats gets you the vampire 'tag', tutting just because you don't gat an answer strait away!! You abviously think that we're obliged to answer your query. 'I've only bumped this thread once per day' you should`nt bump at all, you should take the time to ask yourself, why has no-one answered me, what have I missed/not done? If you had bothered to read the many post on this topic you would already know what extra info is required, but no you think we should do that for you. We cant read your mind or have access to your code, so if you don`t provide all the info that might be needed you wont get an answer. NB. Swearing only gets you banned. :angry: Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al.
♥Vger Posted May 30, 2008 Posted May 30, 2008 Your attitude stinks - that's why you haven't been getting a helpful response. But I'll give you a little hint. In osCommerce admin you have "Display Category Counts" turned on - which relates to cataloging and displaying the number of products in a category alongside the category name. You've got roughly 8000 products, so each time someone loads a page a sql query has to be made which returns a record of the number of those products. That's why your MySQL Query count is so high. For future reference look for the thread "A Store Speed Optimisation In Progress", which tells you this and more about how to reduce unnecessary MySQL queries. Vger
h4x0r Posted May 30, 2008 Author Posted May 30, 2008 I won't try to justify my attitude...I know my response was charged. I'm just fed up with unhelpful responses such as that. While that article was good and all that, it comes from an idealistic elitist mentality. This is a support forum and as long as they exist, you're going to end up with people who ask stupid questions or want someone else to do their work for them. Yes, those people are frustrating to deal with, but as long as there is a a 'support' forum then they will always be there. @Spooks: I didn't think I was asking anyone to do my work for me...I didn't think I was demanding a response. In hindsight I could probably have titled my thread a little differently. Yet, Spooks, this is twice in my thread that you have made grave assumptions about what I have or have not done. I already mentioned that I searched through the forum and google...most likely, I'm not using the correct search phrases otherwise I would have run into this whole slew of posts you're referring to. I'm probably not able to find them because I don't know -exactly- what it is I should be searching for. Originally I had asked about indexing and whether or not there was a discrepancy between my indexes...I even included a screenshot to show what I was talking about. I was NOT asking whether or not any certain code was or was not correct otherwise I would have included it... I really did try to include what I thought was relevant to the question I was asking. @Vger: Thank you for at least pointing me in a direction. It is much more helpful just having an idea of where to look.
♥Vger Posted May 30, 2008 Posted May 30, 2008 Tip - Searching these forums! 1. The Forums' own Search facility is total pap. 2. Searching Google for the phrase you are trying to find is no good - too many results. 3. Answer = whilst on the forum input the search phrase into the Google search box in the Google Toolbar, and then click on the link to "Search only on www.oscommerce.com/forums." 4. That way the results you get will be relevant to what you want to find out. Vger
h4x0r Posted May 30, 2008 Author Posted May 30, 2008 Ahhh, I don't use tool bars in my browsers...too much clutter imo. However, using the same principle I could just run a google search using a 'site:http://www.oscommerce.com/forums' prefix.
♥Vger Posted May 30, 2008 Posted May 30, 2008 Yes, you can do that, but IMHO I wouldn't be without the Google Toolbar. Matter of personal choice I guess. Vger
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.