Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: Use SQL

by vitoco (Friar)
on Sep 04, 2009 at 13:55 UTC ( #793459=note: print w/ replies, xml ) Need Help??


in reply to Use SQL
in thread Combinatorics problem

Using SQL, you can't be sure that the resulting list will preserve the order of the original lists.

Unsorted original lists and the use of primary keys or clustered tables, the query optimizer, size of lists and blocking factor among others are things I can recall that might change the way the output is returned... :-(


Comment on Re: Use SQL
Replies are listed 'Best First'.
Re^2: Use SQL
by herveus (Parson) on Sep 08, 2009 at 11:07 UTC
    Howdy!

    Actually, you can ensure the order of the output, but it requires that the base tables include a column with a sort key. Then you have something you can use in an order by clause.

    Fundamentally, generating the cartesian product of the input lists will generate the elements of the output list. Controlling the sequence is a minor additional task.

    yours,
    Michael

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://793459]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2015-08-30 16:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The oldest computer book still on my shelves (or on my digital media) is ...













    Results (350 votes), past polls