Oops... my bad... :D On 2/6/08, Luis <[EMAIL PROTECTED]> wrote: > That'd be Structured Query Language, don't be that kind to it... > > Cheers, > > Luis. > > > Andre Garzia wrote: > > 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 > >> > > > > > _______________________________________________ > 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
