DB Limitations

[danpadams]

I was wondering, does anyone know where informaiton on what types of queries are counted in this max queries thing?

I was told that the insert command does not count, yet it is a query type. I am rather confused. I am wondering if anyone could shed some light on this.

Dan - http://www.infoChi.com

[HalfaBee]

Only 'SELECT' type queries are used in the 'Max Queries'.

All other types are ignored, otherwise you couldn't restore your DB.

HalfaBee

[danpadams]

I was just trying to figure out related to the database that I have and a desire to go public with it.

Is there anywhere that states how the limits are measured?

Dan - http://www.infoChi.com

[HalfaBee]

The only info on mysql limitations is this thread.

http://forum.powweb.com/showthread.php?threadid=17225

There is no way currently to find out how many queries or connections you are up to.
The only way is to keep track of them in the scripts.

HalfaBee

[danpadams]

I looked over the post in the other thread you showed me. Those numbers look more than reasonable. The question I have left relates to whether or not there is any limit on queries/connection for a given user?

I am simply trying to figure out if there are any changes I need to make to my database and set of php scripts before starting to use them with powweb.com. What I have created as I have stated before is a concordance/topical bible system to include cross references in the future. It keeps track of all of its information through a mySQL database and is easily maintained in a website interface.

it is at http://www.infoChi.com right now and click on concordance to see it (At least its public part) That is the URL I would envision using in association with powweb.com

Dan - http://www.infoChi.com

[HalfaBee]

The 3600/36000 connections/queries are per user per hour.
You are allowed 3 mysql users.

These figures are reasonable unless you have a very busy forum, then you may strike problems.

I tried to load your link but it was very slow.
A site with Powweb will be a lot quicker :)

HalfaBee

[danpadams]

Halfabee,

Part of the reason why the concordance part of the website is slower than the rest is because it is behind a slow (at the moment, Qwest should fix that) DSL modem. That is also part of the reason I want it to be powweb hosted, also I would potentially be able to use it with a school project.

The main reason I was asking about a query/connection limitation is because the database is extensive and I am not sure how many queries are used in each display page.

All of this sounds good so far, I am partially trying to gather information of what improvements I should make to the database system for the school involvement part.

Dan - http://www.infoChi.com