You can switch off all unneeded Filters ans escalations. BR Tristan
----- Ursprüngliche Nachricht -----
Von: lars.j.petters...@vattenfall.com
Gesendet: 14.08.2013 08:32
An: arslist@ARSLIST.ORG
Betreff: Slow import
** <!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000
2px solid; } -->
Hi, I have problem using the import tool, it can take 10 seconds to import one
entry from a file…this has worked fine before with the same code.
We have isolated to problem to the sql below, which is run several
times/record, and this sql takes a lot of time.
T1 is Ar System Message Catalog
There is one index for this form which has been rebuilt without any better
performance
SELECT T1.C1,C152,C155,C156 FROM T1 WHERE ((T1.C8 = '302') AND (T1.C7
= 0) AND
(T1.C150 = 0) AND ((T1.C152 LIKE 'SVE%') OR (T1.C152 IS NULL))) ORDER
BY C152 ASC, 1 ASC
Any ideas?
7.6.04
// BR Lars
_ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
