#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Boston, MA USA
    Posts
    5
    Rep Power
    0
    Hi,

    I was wondering if anyone could detail to me the limitations of MySQL. I've heard various stories about it not handling databases with large numbers of records (100,000+) very well, and about problems with updating, editing, search and replace, etc with MySQL. I'm looking for confirmation of these or information that states otherwise. I have a large site with 200,000 records that will have to be allowed to be updated, edited, removed all from the website.

    Thanks in advance,
    Darcy



  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,645
    Rep Power
    4492
    Mysql can handle 200K rows easily. i was on the mysql listserve and there were people on there running millions of rows. the actual limit on database size is imposed by your operating system, not by mysql. mysql is small and fast, but lacks some of the advanced functions of other databases, transactions, rollback, subqueries. normal people don't even really need these features, though, so it doesn't matter. not having these addons is what keeps it so fast, also. let's not forget it's FREE and very well documented.

    my $0.02

    ---John Holmes...
  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,645
    Rep Power
    4492
    I tried to email you back, but it got returned to me, user unknown.

    Feel free to ask me any questions and I'll try and answer what I can. I'm not a professional, but I use php and mysql a lot for web developement.

    what would you need subqueries and transactions for in a web environment? or is this going to be used for other purposes, too?

    ---John Holmes...

Similar Threads

  1. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 03:16 AM
  2. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 10:05 AM
  3. Replies: 3
    Last Post: July 10th, 2003, 07:47 PM
  4. Error 1045 & MySQL Configuration
    By ksp in forum MySQL Help
    Replies: 10
    Last Post: June 30th, 2003, 07:16 PM
  5. Does CGI have to make up for MySQL limitations?
    By msudbury in forum MySQL Help
    Replies: 2
    Last Post: September 10th, 2001, 07:04 PM

IMN logo majestic logo threadwatch logo seochat tools logo