Advanced Search

Results 1 to 2 of 2

Thread: Quick Question

  1. #1
    Join Date
    Feb 2006
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Quick Question

    Hey DD, I've just got a real quick question. When searching for a hosting company for my website, I always come accross things like MySQL Databases: Unlimited! or MySQL Databases: 30. What exactly does that mean? does it mean that i can only use the mysql_query("Create database") function 30 times?

  2. #2
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,156
    Thanks
    262
    Thanked 690 Times in 678 Posts

    Default

    No, not at all.

    It means you can have 30 databases... like 30 different spreadsheeets.

    You could have a database for your chatroom, a database for your forum, and another one for your email setup. That would be 3.

    Some hosts will only give you 1.

    However, while I think there CAN be limits set on database size, they certainly can be large, and I don't know of any hosts that limit size. For my forum, for example, it's about 30mb right now, of just text. MySQL databases are certainly capable of being huge. Some not quite so nice hosts might limit the size of databases, in which case the number of them would matter.

    In the end, the only reason for more than one database is to keep things seperate. Each database contains tables, then contains rows within those, and data in each cell of each row.
    For example:
    db: forum
    table: members
    row: 1
    cell "username": djr33

    You would probably want totally different things in different databases, but the point is integration. You certainly don't want to be calling from more than one database from the same php script.

    anyway, unlimited may be better, but 30 is surely enough, unless you have some insane need for lots of data storage.
    Daniel - Freelance Web Design | <?php?> | <html>| espa˝ol | Deutsch | italiano | portuguŕs | catalÓ | un peu de franšais | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

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
  •