LISTSERV mailing list manager LISTSERV 16.0

Help for LINUX-L Archives


LINUX-L Archives

LINUX-L Archives


LINUX-L@LISTS.UFL.EDU


View:

Message:

[

First

|

Previous

|

Next

|

Last

]

By Topic:

[

First

|

Previous

|

Next

|

Last

]

By Author:

[

First

|

Previous

|

Next

|

Last

]

Font:

Proportional Font

LISTSERV Archives

LISTSERV Archives

LINUX-L Home

LINUX-L Home

LINUX-L  2007

LINUX-L 2007

Subject:

Re: Sorting Multiple Columns

From:

Dan Stoner <[log in to unmask]>

Reply-To:

Platform Independent Linux List! <[log in to unmask]>

Date:

Mon, 3 Dec 2007 15:32:21 -0500

Content-Type:

text/plain

Parts/Attachments:

Parts/Attachments

text/plain (15 lines)

Jon Lewis wrote:
> If you often need this data sorted, depending on where the data comes 
> from, you might consider using an SQL table to store it.  The table can 
> have indexes sorted on the fields you'd want to see the data sorted in, 
> which spreads the sorting work over the time during which data is 
> entered into the db...making the select that generates sorted data much 
> faster than using sort on hundreds of MB of unsorted data.


That's a good idea... I remember doing that once and there is an "easy" 
mysql command to load the data from a flat file.  Of course, I don't 
have the syntax in my head.


- Dan

Top of Message | Previous Page | Permalink

Advanced Options


Options

Log In

Log In

Get Password

Get Password


Search Archives

Search Archives


Subscribe or Unsubscribe

Subscribe or Unsubscribe


Archives

2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
1998
1997

ATOM RSS1 RSS2



LISTS.UFL.EDU

CataList Email List Search Powered by the LISTSERV Email List Manager