[SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Hi again... 

The bigger thing is that I just loaded up the database with 25,000+ inventory
records! Postgresql handled it nicely, loading them from an .sql file
of insert staements in about 5 minutes.

But when I went to my windows client machine and did an inventory search
on all the items it took nearly 30 minutes to load the page! It worked
though so that's good! The slow down apparently comes from building such
a large page --not so much the transfer via the network. CGI Perl isn't
all that fast. Is there any way to speed this up?

One thing that happened during the course of this load is that Windows
2000 reported that it needed to increase Virtual memory to complete the
operation I bet it did! That's one big .html file!

I have to get this working with this a large inventory. So I'm looking
at adding some selection criteria limitations to the ic.cgi script. I'm
thinking of adding limiting criteria where one has to select the first
and second letter of the search. (i.e. Aa, Ab, Ac...Zx, Zy, Zz) How does
this sound to you all? Any other ideas?




-- 
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com