How many SQL Queries in 1 Second ?

Discussion in 'Programming' started by kaynocks, Aug 31, 2007.

0
  1. #1
    I am planing to buy a Dedicated server with Specs below

    P4- 3.00 GHz Core 2 Duo
    Ram - 2 GB
    Hdisk - 80 Gb
    Bandwith - 800 GB B/with

    My question is bit dummie.. how many sql queries can run in 1 Second in this server config ?? Can some DBA Expert help me here

    My www.webmasteryouth.com has below situation
    MySQL Queries: 14 / Global Parsing Time: 0.8046670
    PHP version: 4.4.6 / Server Load: 0.41 / GZip Compression: Enabled

    Thanx
    Kay
     
    kaynocks, Aug 31, 2007 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2
    That depends on the queries. Very much so.
     
    nico_swd, Aug 31, 2007 IP
  3. kaynocks

    kaynocks Banned

    Messages:
    450
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ohh :( there's no fix standard for generation of queries :(
     
    kaynocks, Aug 31, 2007 IP
  4. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #4
    The more complex your queries are, the longer does MySQL take to deal with them. The speed depends on what the queries do, and on the way they're written. There can be huge differences between queries, so it's VERY hard to say how much you can run in one second.
     
    nico_swd, Aug 31, 2007 IP
  5. garazy

    garazy Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    AS everyone has been saying its hard to gauge as its based on the SQL queries you are running. You need to places indexes on tables that are being hammered. If you intend to store a lot of text data and use LIKE queries that will slow it down.

    If you are using MS SQL you can use SQL Server Profiler to see the start and end time for scripts running on the server.

    Also you say its got 80gig HD, is this a plain IDE disk? That will make a big difference for IO Read Writes.
     
    garazy, Aug 31, 2007 IP
  6. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #6
    You can run run representative queries for your application in phpmyadmin, and note the time to run each query. You may need to run each query at different times to arrive at an average figure. You will then have some better idea of your situation.
     
    Kuldeep1952, Aug 31, 2007 IP