One of the projects I have in mind is to rewrite the catalog so only 20
items are shown at one time. Anyone done that yet that is willing to provide
the code?
Chris Mason
Box 340, The Valley, Anguilla, British West Indies
Tel: 264 497 5670 Fax: 264 497 8463
USA Fax (561) 382-7771
Take a virtual tour of the island
http://net.ai/ The Anguilla Guide
Find out more about NetConcepts
www.netconcepts.ai
Talk to me in real time with Instant Messenger: [EMAIL PROTECTED]
Signature
F331 8AD1 36FB B3B0 DF9F D95B 8024 D1EA 7450 D50C
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Leon Atkinson
Sent: Thursday, March 01, 2001 3:52 PM
To: FreeTrade
Subject: Re: [FreeTrade] Free Trade / MySQL / Ton of SKUs
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]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
