[SQLObject] Enduring long queries outside SQLObject

[Frank B. <fb...@fo...>]

Hallo,

I have to feed my database via a CSV-file from the outside world.
Loading the CSV via Mysql's "load data infile..." query takes a rather
long time and, maybe more importantly, invalidates several SQLObject
instances. This leads to errors in the Webware application I'm
running, where SQLObjects are called, until the Webware AppServer
eventually hangs.  The outside query has a duration of about 10
seconds for 55,000 rows.

Now I'm contemplating strategies against this. I'm not quite sure
where the problems lie, though. The only real "solution" I have is
restarting the Webware AppServer, but I wonder, if I could just as
well "restart" my SQLObjects somehow. 

(And, slightly off-topic here, but I know, many here use Webware: How
do I restart Webware's Appserver in an elegant way from inside
Webware?)

Another solution might be to load the csv into a temporary table and
then run a SQLObject controlled "select into real_table..."

Thanks for any helping insight!

ciao
-- 
 Frank Barknecht                               _ ______footils.org__