SubQuery

[vojoudi]

Hi,

I'd like to know the detailed rules about query limitations in MySQL database.

we are going use a code which will use a sub select query like this:

SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2);

how many queries it will be?? I mean is it just one query of 50,000 queries/hour or 2?

regards,
Vojoudi

[Dbrazzell]

I tested this in mysql and it counted for only one query.

[vojoudi]

Thanks for your help...

Could I ask how can I count the queries? in the MySQL page just shows if I had hit the limits during the last 7 days of not.

Does powweb shows the number of queries or not?

[Dbrazzell]

Sorry we dont show the number of queries used to you the customer.

I can see why it would be a good thing to show them to you.
We show you a bunch of other limits you might be running into.
Disk space
Email
Bandwidth

But mysql is just one of those ones that we dont. I think if we did it might encourage people to push the limit just a little harder on what is already a pretty sensitive resource. I wouldn't worry much about the limits. Only 0.01% of our customer base ever hits the limit. Usually by the time your hitting it your hammering on our other resources as well and should be thinking about upgrading to more expensive hosting solutions such as vps servers and dedicated servers.

[HalfaBee]

Yep, hammering unlimited bandwidth & diskspace indicates overuse of mysql.

You can always test how many queries a query takes by trying it 75,001 times in an hour. :)

[entrecon]

You can always test how many queries a query takes by trying it 75,001 times in an hour
Hmmm, that is a good point. I sometimes feel that I am under-using the services I get from PowWeb. If I set a script up to run say 65,000 queries/hour I could use the services and not feel like they were just sitting there wasting away. :eek:

[Doc C]

I'm like you, entrecon. I have all this webspace and bandwidth and only use a small fraction for a blog that no-one but me sees. I need to create a GINORMOUS site.

[satis]

both you guys better get a dedicated server first. :p

[entrecon]

Do you know how many queries and how many things I would have to upload if I got a dedicated!!!