Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re: Managing Inventory Sections with Perl and SQL

by dga (Hermit)
on Jul 29, 2003 at 15:56 UTC ( [id://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?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2024-04-24 04:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found