Thread: database server

    #1
  1. No Profile Picture
    fcatz
    Guest
    Devshed Newbie (0 - 499 posts)
    I intend to set a database server running in the not so far future and id like to know a few things here. Firstly what kind of speed can i achieve with MySQL? I hear of tables with millions of rows but i have no clue how fast data can be retrieved yet. I also hear ppl complaining about subqueries not available on mySQL, what exactly are they anyway? And finally, could someone running a database server give me some basic info concerning bandwidth vs # of hits.
    Answers would be very appreciated.
    Thanks.
  2. #2
  3. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    Here's a link to the benchmarks listed on MySQL's site. It should provide you with all of the information you need about benchmarks and speed.
    www.mysql.com/benchmark.html

    And here is the scoop on subqueries. A subquery is basically a way to combine to queries into one. Here is a link that should be able to explain it better.
    http://www.geocities.com/SiliconVall...n%2FSubqueries

    [This message has been edited by moderator (edited 09-28-99).]

Similar Threads

  1. Replies: 2
    Last Post: July 20th, 2003, 03:47 PM
  2. Export SQL server 6.5 Database to SQL Server 2000
    By chandru118 in forum Database Management
    Replies: 0
    Last Post: June 4th, 2003, 01:34 PM
  3. Replies: 2
    Last Post: November 5th, 2001, 03:40 PM
  4. Moving a database to a different server
    By ashalson in forum MySQL Help
    Replies: 5
    Last Post: July 15th, 2001, 12:31 PM
  5. Replies: 3
    Last Post: July 3rd, 2001, 12:24 PM

IMN logo majestic logo threadwatch logo seochat tools logo