Tiemo, I've been using both RDBMS and flat files. A quick opinion is that with SQL you don't need to reinvent the wheel and this is specially good when you're going to do cross references and searching. SQL stands for Simple Query Language, it's really easy to make queries with SQL.
With flat files, you need to roll your own search routines and this can be a huge bottleneck on your code. If you go brute force looking every single record in your thousand+ database, you're sure that will take a while. If you decide to optimize your searches and build your own indexing and searching, then you'll spend a lot of time in there. So, for my projects, I settle like this: if there's heavy searching go with SQL, if it's just data storage and retrieval, then stack files will do. I must say, I am in love with stack files, they are so flexible! Cheers andre On 2/6/08, Tiemo Hollmann TB <[EMAIL PROTECTED]> wrote: > Hi Derek, > > > > > Like I said though, it depends entire upon the type of database you are > > working with. I don't use SQL as I find it to be rather bulky. I use > > Flat Files, and I write all of my own database handlers, so my coding is > > not dependent on SQL or some other type of database and it's limitations. > > Interesting to read, did you ever compared the performance on "big" datas? > Up to now I havn't found a performing way how to loop through 20.000 records > in a flat file for generic selection with a search term compared with a > select - where. Looping through 20.000 records and searching for a sting > with lineoffset() to select a list of datas wasn't fast enough for me. > Perhaps you found a better trick? > > Tiemo > > > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > -- http://www.andregarzia.com All We Do Is Code. _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
