Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re: Managing Inventory Sections with Perl and SQL

by dga (Hermit)
on Jul 29, 2003 at 15:56 UTC ( #278875=note: print w/replies, xml ) Need Help??

in reply to Managing Inventory Sections with Perl and SQL

I would add 2 things to what has been said.

An index on the section field should make lookups of section efficient.

When I have done similar things, I have had prices in a seperate table with an effective date so that prices could be changed by a date and historic price info could be gathered.

So for your sale example, say that from August 1-8 you were having a sale then you would have 2 entries in the price table for your item one with the sale price and August 1 and one with the normal price for August 8th. A sale boolean could also be put in this table to indicate sale prices if desired etc.

  • Comment on Re: Managing Inventory Sections with Perl and SQL

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2021-06-23 18:17 GMT
Find Nodes?
    Voting Booth?
    What does the "s" stand for in "perls"? (Whence perls)

    Results (121 votes). Check out past polls.