Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: test speed

  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,958
    Thanks
    120
    Thanked 76 Times in 76 Posts

    test speed

    Whichever gui I try for running queryies it works lik this:
    1.first run, takes like 5 sec
    2.all next emidiate runs of same queriy takes 0,03 sec. (looks like server caches something ?)

    How can one then real test query speed ?
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #2
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,958
    Thanks
    120
    Thanked 76 Times in 76 Posts
    http://www.techiecorner.com/45/turn-...y-performance/

    so, this:
    Code:
    SET query_cache_type = 0; RESET QUERY CACHE ;
    affects this:

    Code:
    SHOW VARIABLES LIKE '%query_cache%'
    & affect speed, to be 'slow'
    Last edited by BubikolRamios; 11-02-2011 at 02:28 AM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •