[ic] Shipping in Interchange 6

Stefan Hornburg (Racke) racke at linuxia.de
Mon Jul 28 10:41:39 UTC 2014


On 07/26/2014 05:34 AM, Greg Sabino Mullane wrote:
>> The conditions are in a tree structure and a shipment rate belongs
>> the root node of one these conditions.
> 
> I'm not sure why this warrants the complexity of a tree (perhaps a 
> better example?), but:
> 
>> Adjacency list
>> Nested set
>> Closure table (aka bridge table)
>> Materialized path (path enumeration)
> 
> Adjacency list should be ruled out if we still want to support MySQL (no CTEs!)
> 
> I think any of the others will be fine. The data set will be so small I don't 
> think relative read or write speed should really matter. I would find one 
> that is familiar to whomever wants to champion/write it. FWIW, I prefer 
> nested set for smallish data sets.

Thanks for your advice. If we could avoid the complexity of a tree,
that would be good. Do you have a suggestion how to structure the
shipment conditions into a linear fashion in the database?

Regards
	Racke



-- 
Perl and Dancer Development

Visit our Perl::Dancer conference 2014:

http://act.perl.dance/



More information about the interchange-users mailing list