SV: Slow import
Server reboot helped, now fast as expected…☺ // Lars Från: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] För Danny Kellett Skickat: den 14 augusti 2013 09:48 Till: arslist@ARSLIST.ORG Ämne: Re: Slow import ** Lars Have you run this query outside the AR system? E.g. Through SQLplus / SQL query analyser? Regards Danny On 14 Aug 2013, at 07:31, lars.j.petters...@vattenfall.commailto:lars.j.petters...@vattenfall.com wrote: ** 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_ _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
Slow import
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
AW: Slow import
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: #80 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
Re: Slow import
Lars Have you run this query outside the AR system? E.g. Through SQLplus / SQL query analyser? Regards Danny On 14 Aug 2013, at 07:31, lars.j.petters...@vattenfall.com wrote: ** 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