Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2006
    Posts
    3,970
    Tokens
    0

    Latest Awards:

    Default Flat File DB question

    At the moment im making a usersystem, and the usernames, passwords, ect are been stored in a flatfile like

    Username|password|name|email|age
    Username|password|name|email|age
    Username|password|name|email|age
    Username|password|name|email|age

    Ive created a small function to search through the text file for when you login, create your account, and modify the details.

    How long will it be before it starts to create lag because of the size of the file?
    Lets set the stage on fire, and hollywood will be jealous.

  2. #2
    Join Date
    Oct 2006
    Location
    Peterborough, UK
    Posts
    3,855
    Tokens
    216

    Latest Awards:

    Default

    I dunno, get SQLite. It doesn't need installing, it's a self contained no config db.

  3. #3
    Join Date
    Mar 2008
    Posts
    5,108
    Tokens
    3,780

    Latest Awards:

    Default

    How are you even protecting that file, also don't make it like cutenews and have the search function as the news search as well.

    As Dan said, get SQLite.

  4. #4
    Join Date
    Dec 2006
    Posts
    3,970
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Dentafrice View Post
    How are you even protecting that file, also don't make it like cutenews and have the search function as the news search as well.

    As Dan said, get SQLite.
    The file is in a dir with htaccess on it. Yeah, i will get SQLite then, Thanks
    Lets set the stage on fire, and hollywood will be jealous.

  5. #5
    Join Date
    Dec 2007
    Posts
    1,683
    Tokens
    0

    Latest Awards:

    Default

    Copy and paste it in notepad, and see what a reasonable loading speed is, and keep multiplying the fields, and see at what rate it crashes on your computer, although the web server is probably more powerful than your computer

  6. #6
    Join Date
    Dec 2006
    Posts
    3,970
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Minor View Post
    Copy and paste it in notepad, and see what a reasonable loading speed is, and keep multiplying the fields, and see at what rate it crashes on your computer, although the web server is probably more powerful than your computer
    Its too late now! ive changed it all to MySQL!
    Lets set the stage on fire, and hollywood will be jealous.

  7. #7
    Join Date
    Dec 2007
    Posts
    1,683
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Tom743 View Post
    Its too late now! ive changed it all to MySQL!
    Fair enough

Posting Permissions

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