Re: [mv] Detailed product info strategies

[cfm@maine.com]

******    message to minivend-users from cfm@maine.com     ******

On Tue, Jul 25, 2000 at 10:20:57AM +1000, Simon B wrote:
> ******    message to minivend-users from Simon B <music@labyrinth.net.au>     ******
> 
> I have been thinking this over for a few weeks and would 
> like to hear some thoughts of the more experienced mvend
> users as I imagine it must be a very common exercise.
> 
> The aim is to add "very" detailed product information
> to a db_file database to initially use for display with 
> the flypage.
> 
> On a regular basis these detailed pages will be created
> as static files, primarily for search engine submission.
> 
> The additional information comprises of approximately
> 20 fields. Extra images, specs etc. Several of the fields
> will be quite large detailed descriptions consisting of
> many paragraphs of information.
> 
> The questions:
> 
> Should I add all of the extra fields and data to the 
> existing products.asc (easy route for many reasons)
> or would this be too cumbersome? 
> 
> Would there be any advantage/disadvantage to holding
> the "detailed info" in an arbitary database?
> 
> I am using 3.14

Cumbersome depends on how you load the tables.

We generally strip everything possible out of our products
db and put details in a second aux db.  "very" detailed information,
typically specs, would go in another.  You might have a
field in products (or aux) that keys to the specs table; it is
very common for one spec to apply to many products.

A category page might need only products, an intermediary might
look at products joined with aux, and nothing but flypages
and searches would look at specs.





> SB
> 
> 
> 
> 
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-- 

Christopher F. Miller, Publisher                             cfm@maine.com
MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
1.207.657.5078                                       http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list