MySQL Database and query requests! please HELP!

Question

1.00/5 (2 votes)

See more:

Hello,
I have a wordpress website and it always goes beyong my host's query limit, even when I am just writing posts. The customer support told me I could set my queries to reset more often. he even gave me a link:
http://www.sitepoint.com/optimizing-mysql-application/[^]

The problem is that I have no idea what it says and I dont know anything about queries and databases! I know ftp so i can modify my files but if someone could help me/explain to me it owuld be very appreciated! thank you

Posted 24-May-14 10:20am

Member 10837066

Add a Solution

Comments

[no name] 24-May-14 16:34pm

It says "create indexes for your database tables".

Member 10837066 24-May-14 16:35pm

so what should i do?

[no name] 24-May-14 16:45pm

Well if I was you, I would be creating indexes for my database. If you are unwilling or unable to do this yourself, then you need to go find a website where you can hire someone to do this for you.

Member 10837066 24-May-14 16:47pm

Then what is your forum for? You're a funny guy

[no name] 24-May-14 16:50pm

This forum is to help programmers with programming problems. It is not a website where you can get someone to work for you for free.

Member 10837066 24-May-14 16:48pm

A forum is a place where you can ask questions and get answers not a website where someone tells you to go f*** yourself

[no name] 24-May-14 16:51pm

You asked a question and you got your answer. Sorry if it was not the answer that you was looking for. You are not going to get anyone on StackOverflow to do your work for you either.

Member 10837066 24-May-14 16:52pm

I will because i always do. I just thought I'll try here

Member 10837066 24-May-14 16:49pm

imbecile

[no name] 24-May-14 16:52pm

Oh boy that really hurts coming from someone such as yourself.

Member 10837066 24-May-14 16:54pm

Such as myself? all you know about me is my login and potentially my IP address and current location, you don't know me, you don't know that I probably make 10 what you make in a year every months. Please go back to your dark basement with your old computer to not* answer questions. Thank you.

[no name] 24-May-14 17:01pm

Oh please. You can't read or follow simple directions and call me an "imbecile". If I am such an imbecile, what does that make you?

Member 10837066 24-May-14 17:03pm

Simple directions? Simple for you little guy, you are an experimented programmer, I am sure only a very very minuscule number of people could understand this. It is not because I do not understand a specific topic that I am an imbecile. However, telling someone to stop asking questions on a forum, well THAT is imbecile. Sorry to break it to you.

[no name] 24-May-14 19:31pm

That, sir, simply proves my point. No one at all told you to stop asking questions at any point in time. You were simply told the answer to your "question" and to go create indexes for your database. If you are unable to read and follow the very simple instructions that you was directed to, you was also told that you would need to hire someone to do it for you as we don't do for hire work on this website. You are the one that took insult where none existed or was offered. You was the one that started name calling for no reason at all. So, who again is the imbecile?

Member 10837066 24-May-14 19:33pm

you 'was'?
Please learn proper english, and send a reply.
And again, these are not 'simple' instructions for 99.9% of people. So be smart. This message will be the last I post here I have more important business to get to.

[no name] 25-May-14 6:30am

Oh good. Does that mean that you are going to stop being a troll? I will tell you what, you learn proper English first then you can have some reason to point out any flaw in my sentence structure. You just run along now. Big rich company president that you are must have way more important things to do. I think I hear your mommy calling.

Member 10837066 24-May-14 16:48pm

I'll just put it on stackoverflow where people answer

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NewPast · Answer 1 · 2014-05-25T05:45:00

This is about un documented limit of your hosting provider
You have this solution
* create multi user for one database and select on at random whenever one call your site
* enable a good caching plugin
* switch to use sqlite as wp database; if you have a small site
* change your hosting provider and this is the real best of all solution

* many hosting provider that offer wp hosting they do not support real traffic on it, and put lots of undocumented limits.

if you plan to pay 4$/m you may try: http://www.arvixe.com/coupons[^]