Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Jun 2011
    Posts
    4
    Member #
    28097
    Is there any example how to auto create a subdatabase for each user who register?
    I mean when a new user is register i want to have his own subdatabase in case to have fast search and editing.

    Also is this a good solution?

  2.  

  3. #2
    WDF Staff AlphaMare's Avatar
    Join Date
    Oct 2009
    Location
    Montreal, Canada
    Posts
    4,570
    Member #
    20277
    Liked
    878 times
    Quote Originally Posted by vsikariam, post: 208315
    Is there any example how to auto create a subdatabase for each user who register?
    I mean when a new user is register i want to have his own subdatabase in case to have fast search and editing.

    Also is this a good solution?
    A good solution for what?
    What is it you want to do with the database - the use to which it will be put will dictate how it is set up, what tables it should have, etc.
    Good design should never say "Look at me!"
    It should say "Look at this." ~ David Craib


    http://digitalinsite.ca ~ my current site . . info@digitalinsite.ca ~ my email

    If you feel that someone's post helped you fix your problem, answered your question, or just made you feel better, feel free to "Like" their post. The "Like" link is at the bottom right of each post, along side the "reply" link. And if you are being helped here, try to help someone else - pass it on!

  4. #3
    Senior Member LeenkzMike's Avatar
    Join Date
    Jan 2011
    Location
    Toe-Peek-ah, Kansas
    Posts
    608
    Member #
    26365
    Liked
    80 times
    From a server load stand point, I dont think there would be a difference between having a database for each user or keeping everything on one database. But I might be wrong.
    Peace, Mike
    WebHost1-For all your Hosting needs.
    Leenkz.Com-The web starts here! (Blatant use of tables)
    I realllllly need to feel useful, please "like" my signatures!!!! (Button is on the bottom right!)

  5. #4
    Junior Member
    Join Date
    Jun 2011
    Posts
    4
    Member #
    28097
    I mean that, my project evrey user is going to save 100 of information and settings and i think it would be better if evrey user have his own database in case to have a smooth, faster and clean database or is wrong?

  6. #5
    Senior Member Webzarus's Avatar
    Join Date
    May 2011
    Location
    South Carolina Coast
    Posts
    3,322
    Member #
    27709
    Liked
    770 times
    MySQL DB's can handle tens of thousands of records in a single DB with no server impact ( a DB is for storage of records ).... it's usually how to data is inserted and or retrieved that is going to put a load on the server... bad code can slow a server to a crawl... a typical setup should be able to get a thousand records in under a second with minimal impact on the server

    Again, depending on the actual DATA that you will be storing and how that data is related to all the other users data... or if there is a reason to correlate "ALL THE USERS DATA" ... would best determine if and how the tables are setup...

    what you are asking is very vague, if you could provide more detailed information about the DATA ( examples )... and how the overall data is going to be used ( Will all user data ever have to be tied together for any reason? )... you may get some more detailed suggestions...

    Typical DB setups would have users in 1 table , data of the same kind in 1 table each, etc....

    what you are asking for ( If I understand the questions ).... is a "create table" script that when some registers, the script will create that users DB for them to enter information...

    Depending on the Hosting platform you are using for your DB server... it may be different... you'll need the connection string information and a basic sql script to create the table for the user...


Remove Ads

Posting Permissions

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

Search tags for this page

create subdatabase mysql
,

mysql subdatabase

Click on a term to search for related topics.
All times are GMT -6. The time now is 10:32 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com