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 3 of 3
  1. #1
    New Coder
    Join Date
    Dec 2003
    Location
    USA
    Posts
    11
    Thanks
    1
    Thanked 1 Time in 1 Post

    Mysql or Text file for Mass users?

    Hey , im building this website , on which in a part of it, i currentlly use a Mysql Db to store the profiles, but 1 user, can create serveral profiles ( dont ask .. ) , i was wondering if for a mass population accessing it , lets say about 80 Thousand users, if it would be better to use Text Files (some kbs each) , or keep using the mysql DB?

    Thank you !
    Last edited by seetherage; 02-25-2007 at 11:46 PM.

  • #2
    Regular Coder Rappa's Avatar
    Join Date
    Nov 2005
    Location
    LI
    Posts
    356
    Thanks
    21
    Thanked 9 Times in 9 Posts
    i would think with mysql you would have much more creative freedom, i never used txt files for that kind of thing. but i would assume they would be somewhat unreliable, otherwise your not limited to the number of databases you can use to store users (except by your hosting service) otherwise id create a script that would change to a new db when one fills up, say like to 10k or somthing. otherwise mysql has been and always will be a reliable source for mass storage, until somthing new comes out.

  • #3
    New Coder
    Join Date
    Dec 2003
    Location
    USA
    Posts
    11
    Thanks
    1
    Thanked 1 Time in 1 Post
    yea, i've ran several stress tests, and got good results from them .
    i was even thinking about Oracle , but hey!! Thankkkk youu!!!
    You helped alot.!!! thx !!


    Gui


  •  

    Posting Permissions

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