[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Importing customers

On 11/1/06, Charley Tiggs <..hidden..> wrote:
Thanks Chris.  Testing just got a whole lot easier!  :)

Just one further thought.  One of the issues with the current LSMB/SL
architecture (will be fixed in 1.2) is that it makes a new database
connection every time an API is called.  This means that in order to
insert a bunch of customers, your logic looks like this (even if you
could chain all the API calls into one script, but you probably have
additional forking overhead):

Lable 10
connect to database
insert row
select row
update row
disconnect from database
if more records, go to 10

Needless to say, this doesn't work well for bulk imports :-)  For 1.2,
I am working on a new CLI script host that may be more helpful.  It
will be experimental for the 1.2 code and plans are to formalize it
for 1.3.  This will be noticeably better, but will still leave a lot
to be desired.

Best Wishes,
Chris Travers