On Wed, Feb 4, 2009 at 9:43 AM, Jônatas Zechim <zechim....@gmail.com> wrote:
> Hi there, i've a system that do a query each 3s, does it impact on mysql > Server? > I mean, can this slow my Server? > > zechim > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > It impacts system recources if this same query is run constantly for each user. Example: if this runs a logon and you have 100 or 1000 users logging on at roughly the same time, then you will have contention for the resources. Can you check your indeces and run explain plans on the queries to see if any of them can be optimised to run quicker? -- Bastien Cat, the other other white meat
