[Tutor] Best approach to sort data based on several criteria

Bob Gailer bgailer at alum.rpi.edu
Wed Aug 13 17:48:17 EDT 2003


At 03:02 PM 8/13/2003 -0700, Danny Yoo wrote:



> > >I have a huge amount of data that's stored in a file where each record
>             ^^^^^^^^^^^^^^^^^^^
> > >is in a line made of 22 columns, and each column is separated from the
> > >other by a ';'.
>
>
>Hi Jorge,
>
>Hmmm... When you say "huge amount of data", can you be more specific? If
>you're taking about several megabytes, then we don't have much to worry
>about.  But if we're talking about hundreds of megabytes (or even
>gigabytes), then we have to be a bit more careful.
>
>
>If your set of data is really humongous, you may want to consider using a
>database management system --- such as PostgreSQL or MySQL

Please add SQLIte to that list.

>  --- to do the
>brunt of the sorting and storage grunt work.  Can you give us an estimate
>of how large your dataset's going to be?

Bob Gailer
bgailer at alum.rpi.edu
303 442 2625
-------------- next part --------------

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003


More information about the Tutor mailing list