PDA

View Full Version : Flat File DB question



Decode
07-06-2008, 12:18 PM
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?

Agnostic Bear
07-06-2008, 12:22 PM
I dunno, get SQLite. It doesn't need installing, it's a self contained no config db.

Dentafrice
07-06-2008, 12:33 PM
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.

Decode
07-06-2008, 12:35 PM
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 :)

Independent
08-06-2008, 04:01 AM
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 ;)

Decode
08-06-2008, 03:51 PM
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!

Independent
09-06-2008, 01:54 AM
Its too late now! ive changed it all to MySQL!
Fair enough :P

Want to hide these adverts? Register an account for free!