SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Sep 2008
    Posts
    341
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    What do you think of my database response times?

    Please only respond if you have actual experience that can compare. It would be pointless to just say "that sounds good/bad". Thanks.

    If anyone could do some tests of their own - now that would be good!! (just 3 or 4 would be enough)

    Thank you for all help - I need to make a decision and responses here will go a big way towards that - so this is pretty important to me.

    My site is very important and requires a good level of speed - it is not just a 2 visitor-per-day hobby site.

    I am NOT using MySQL, but I am using an API through php for the database.

    I would like to know if the API service I am using is very good. I.e would MySQL be quicker? What would you expect to get?

    The API is ran on a shared server - but shouldn't have too many domains.

    For the test, the main .php files were on a shared server with thousands of domains!

    For all tests there was no html output, and no php (other than is necessary - it is purely to test the database API)

    A WHILE loop was used to hit the API 100 times with an "insert" action for the 100 records below. Maybe FOR would be better, but it was done using WHILE. I think this is the best/only way.

    When I launch this site, I will use a dedicated server for my main files - and "could" get the database API company to provide a dedicated server (all at cost of course) - there is a good budget to get things right - but many pages already have been coded (and tested already) using the API rather than MySQL - so changing to MySQL would be a big job.

    The question is: Are these times any good - or should I look elsewhere for my database?

    ----------

    Test 1: Add a new table, create 3 fields, add 100 records field1 and 2 were just 8 characters of garbage / field 3 was number 1-100
    Then, pull all 100 records from the table and display to user.


    Time was between 0200-0300 GMT

    Times taken: (18 tests)
    seconds:
    51
    73
    49
    85
    64
    72
    67
    68
    82
    73
    60
    80
    51
    75
    72
    43
    62
    75


    ---------------

    Test 2 was the same as above - but just adding 1 record and returning that 1
    (6 tests)
    seconds
    7
    5
    6
    7
    6
    9

    Thanks for reading.

  2. #2
    SitePoint Wizard
    Join Date
    Jul 2003
    Location
    Kent
    Posts
    1,921
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I regularly update a MySQL database with an extract from a club's off line database. I add in the region of 12 - 14,000 records, twice, in about 20-25 seconds each, via SQL Manager lite for MySQL, by EMS, and two files containing the data extracts on my home PC. The text files are typically 800 - 900kb, one set of records is about 40 - 50 characters spread over nine fields, the other is 40 - 100 characters spread over five fields.

    Does that help?

    Looks slow to me for 100 records.

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    you're not going to get the type of answer you're looking for. how can anyone possibly say that the performance of your API is good or bad based on the data you've provided here?

    my suggestion is: don't reinvent the wheel. use a real database engine if you want database-like behaviors. use sqlite if you don't want to run a database server.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  4. #4
    SitePoint Addict
    Join Date
    Sep 2008
    Posts
    341
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When I posted this I thought the times were a little slow - but wasn't sure.

    I have tested using MySQL (after spending a couple of hours learning it.)

    50 seconds down to "half" a second. GOOD BYE API !!!!!!!!!!

    I see what longneck is saying - but actually if I had not posted on here I may have just stuck with the API - so I did get the answer I wanted - and am absolutely delighted.


Bookmarks

Posting Permissions

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