Text File database

[thendal]

Hai!

Iam using a text file database.Is there any limitation in using flat file database.

Like flat files can hold only this many amount of datas ....

I having an application which will be populated daily with 5-10 records.

Is there any way the flat file will crash.

Please advise me.

Thendal [sig][/sig]

 

[goBoating]

I don't think the use of flat files is limited by whether or not the system (OS) will crash or fail to operate correctly. After all, file I/O is a very basic OS behavior. Any OS had better be able to do it dependably. There may be some limitations inherent in the way you are managing the data ( if you are using a module or function that might have some limitations.... better be doing some flocking if multi-user, etc...).

If there are no limitations in the way you are managing the data, I don't think stability would be the problem. Rather, I think you will find the querying and updating the database will become unacceptably slow as the data set grows. I routinely use flat files for simple web stuff and have data sets of several megs that perform quickly and dependably with simple indexes. All I would suggest, is that you do a good job of modelling your data, so that if/when you see unacceptable performance, you can easily port your data into a more robust db engine.
[sig]<p> <br><a href=mailto: > </a><br><a href= > </a><br> keep the rudder amid ship and beware the odd typo[/sig]

 

[thendal]

Thank you so much.Iam little bit worried about flat files.
Now its ok.


;-)
[sig][/sig]

 

[MikeLacey]

5 -> 10 records per day...... should be ok for a while

have a look at DBI in the meantime though [sig]<p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Making mistakes, so you don't have to. &lt;grin&gt;[/sig]