On Fri, Jul 26, 2002 at 10:54:06PM +1200, Matt wrote: > It has raised one particular point, which is probably generic to any > interfacing project, including the SL 'future todo' to create a better > customer-selection option than a single (possibly huge) drop-down field.
Yep, I have done exactly that for a customer. This was on the 1.6.x series, though. It took me about 20 hours to do it, and a lot of that had to do with me not knowing SL while knowing Perl. I made it so that the sales associate had to start off by searching for the customer (or adding a new customer). It then goes directly to the customer invoice screen, with no drop down box. I had to do this because there were 20,000 some odd customers, with more walking in the door every day. (Can you imagine Netscape 4 rendering that many customers??) I don't know if this was in the stock 1.8.x series, but if you guys are going to scale your stuff to that number, you might want to check out the indexing on the SQL side. The stock 1.6.x was extremely slow with that large of a dataset, and adding the indexing made the response a lot quicker. If the dataset is pretty small, you probably won't notice a thing. -Qaexl- ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
