7000 SKUs is not a problem from a database perspective. You probably
shouldn't worry about queries being slow until you get up near 100,000. You
will have a problem if you use the quick order screen. Since that screen
tries to put every item in one big table, the limit is about 20 items.
Likewise, if all the items are in one department, you might face problems
with browsers rendering such a huge page. You have a similar problem with
the admin interface. As long as things are divided into subdepartments,
you'll be OK.
Your biggest problem will be the human time needed to maintain such a huge
catalog. There are probably some enhancements to be pursued that would
smooth things out for site with this many SKUs.
Leon
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
