>
> How about if I have a web shopping cart interface to SQL-Ledger?
> Everyone who orders via the web will need to be added in as a customer?
> If you run a website where each surfer probably will order only once or
> twice, that could be millions of customers (if you're luck) in the db
> who are just "stale" customers? That would slow the drop down list a bit
> no? What is the best way to handle this type of situations?
>
i replaced the pulldown with a stored prodecure that only shows me
active customers (in the last 120 days), unless they have credit or
balance issues, that my shopping cart didnt automatically create (lacks
the web_% prefix)
i dont know much about the employee things still eating BB&J
myself and the rest goes to network appliance :)
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
