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 10 of 10
  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    Raleigh, NC
    Posts
    484
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access limitations

    I did a search so I'm pretty sure I'm not repeating an earlier thead... I've heard something like access can only hold 10,000 records, or something about its data capacity. I'm just trying to find out if there is any truth to it or if I can expand it indefinitely with the understanding that the weight (size) of the db will become huge and cumbersome. I need to find out before I start my next project because it will require connecting several tables within several databases. Any body know or heard anything like that?
    -WebMark Art
    Programming is 80% thinking and 20% spelling

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,040
    Thanks
    10
    Thanked 92 Times in 90 Posts
    there is a limit to table size in MSAccess though I thought it was a little higher than that, but I would suggest that on that scale MS access will fall apart under the pressure long before you run out of record space
    If you are tied to MS then SQL server is proably your next best bet, with SQL server or even MySQL the only limit is disk space + they are much more able to handle the queries you would be throwing at them
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    Mega-ultimate member
    Join Date
    Jun 2002
    Location
    Winona, MN - The land of 10,000 lakes
    Posts
    1,855
    Thanks
    1
    Thanked 45 Times in 42 Posts
    I've heard the Access can only handle about 10 connections at once before it crashes. Anyone know if that's right? If so, how many simultaneous connections can mySQL handle?

  • #4
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    http://www.mysql.com/documentation/m...tml#Table_size

    When they Refer to 'Linux-Alpha' by the way, they mean if you have a Alpha Processor based server.

    From MySQL documentation:
    Handles large databases. We are using MySQL with some databases that contain 50,000,000 records and we know of users that uses MySQL with 60,000 tables and about 5,000,000,000 rows
    I believe with MySQL the number of connections ultimately is a matter of how many simotanious connections the OS can handle.

  • #5
    Regular Coder
    Join Date
    Jul 2002
    Location
    Raleigh, NC
    Posts
    484
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am familiar with SQL Server/Oracle 8, how much different is My SQL. I already checked with my hosting company and they support MySQL. Would there be any additional cost to use MySQL? Not to be a pain, but if someone could give me a brief explanation on how access, sql, and mysql are different, I would reall appreciate it.
    Last edited by webmarkart; 08-03-2002 at 08:34 AM.
    -WebMark Art
    Programming is 80% thinking and 20% spelling

  • #6
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts

    Arrow

    Well the differences... hmmm... Well Access is designed for smaller scale uses. And isn't very efficent nor fast compared to MySQL or SQL. MySQL is a very scalable program, and it is covered under the GNU public license, so that if I'm not mistake allows you to alter the source of the softare to suit you if you need to. Plus MySQL is free while Access isn't that expensive. SQL can be... very expensive especially for web servers that are multi-processor. SQL has a lot of good features and capabilites, for example being able to publish data from one table in an SQL server to another SQL server automatically.

    As for system requirements, I know from personal experience SQL can be a memory hog. I had a server that kept crashing because it only had 512MB of RAM and with SQL recieving constant data is would lock up about every 25-26 hours. Doubling the ram seemed to have solved that problem. MySQL on the other hand is pretty light from what I've seen. I haven't used a MySQL database for heavy querying yet or 100,000s records either.

    Hope that helps.
    Last edited by oracleguy; 08-03-2002 at 10:02 AM.

  • #7
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,040
    Thanks
    10
    Thanked 92 Times in 90 Posts
    Also whilst MySQL uses pretty much standard SQL it also has a few non ANSI commands as well (thats neither good nor bad just a statement !)

    MySQL also lacks some of the functionality of 'true RDBMS's' - it does have transactional capabilities but no foreign keys nor triggers nor stored procedures to name the major complaints) of the above you are likely only to have come up against foreign keys (in general web-usage) which most PHP'ers have got used to coding around.
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #8
    Regular Coder
    Join Date
    Jul 2002
    Location
    Raleigh, NC
    Posts
    484
    Thanks
    0
    Thanked 0 Times in 0 Posts
    First I just want to say thanks for everyone who has replied, you've all been helpful so far...

    Okay, I went to mysql.com and downloaded MySQL 3.23 (mysql-3.23.51.zip). I ran the setup and installed it... It created a mysql folder on my c drive but nothing I click on in the folder opens anything. I want to be able to create mysql databases, did I download the right thing? How do I transfer contents from an access db to mysql?
    -WebMark Art
    Programming is 80% thinking and 20% spelling

  • #9
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,040
    Thanks
    10
    Thanked 92 Times in 90 Posts
    MySQL has a command line interface or you can access it via 3rd party GUI's or via a web-based interface such as phpmyadmin.

    there are a couple of GUI's on the mysql site for download but my favourite (especially for import from MSaccess etc) is MysqlFront
    which you can grab from

    http://www.mysqlfront.de

    , another useful download would be MyODBC from mysql.com which lets other ODBC based apps talk to MySQL
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #10
    Regular Coder
    Join Date
    Jul 2002
    Location
    Raleigh, NC
    Posts
    484
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Okay, I downloaded MysqlFront and I was attempting to set up a connection, but obviously since i am posting again it did not work! I tried entering the domain with the ftp id and passsword but I get an error so I tried entering the ip address... nope! What am I doing wrong now? Am I just being a spaz or what?
    -WebMark Art
    Programming is 80% thinking and 20% spelling


  •  

    Posting Permissions

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