Click here to Skip to main content
15,743,426 members
Home / Discussions / Database
   

Database

 
QuestionSelecting from three tables? Pin
NewToAspDotNet10-Jul-08 4:55
NewToAspDotNet10-Jul-08 4:55 
AnswerRe: Selecting from three tables? Pin
leoinfo10-Jul-08 5:05
leoinfo10-Jul-08 5:05 
QuestionExport from Visio to Mysql or From MS Sql Server to mysql Pin
Mohammad Al Hoss10-Jul-08 4:28
Mohammad Al Hoss10-Jul-08 4:28 
QuestionParse values in SQL SP Pin
sqldba10-Jul-08 3:21
sqldba10-Jul-08 3:21 
AnswerRe: Parse values in SQL SP [modified] Pin
leoinfo10-Jul-08 7:18
leoinfo10-Jul-08 7:18 
QuestionPattern matching to list in sql Pin
Member 469462710-Jul-08 2:21
Member 469462710-Jul-08 2:21 
QuestionRe: Pattern matching to list in sql Pin
TheFM23410-Jul-08 4:49
TheFM23410-Jul-08 4:49 
QuestionOPENXML() and performance Pin
Kjetil Svendsen9-Jul-08 22:29
Kjetil Svendsen9-Jul-08 22:29 
Hi.

I have a stored procedure, and it's working fine.
One of the input parameters is XML (@p_xml) and is processed like this:

DECLARE @docHandle int
EXEC sp_xml_preparedocument @docHandle OUTPUT, @p_xml

SELECT * INTO #raw_table 
FROM 
OPENXML(@docHandle, '//NODE', 2)  


The problem is when the XML is really big (~20 MB with ~35000 nodes). Then the OPENXML statement uses 7-8 minutes to finish.

Is there any way to speed up OPENXML, or is there any other workaround ?

I have tried both select into and insert into and both temp table and table variable. All with the same result.

Could someone help me ?

Kjetil
AnswerRe: OPENXML() and performance Pin
Ashfield10-Jul-08 1:41
Ashfield10-Jul-08 1:41 
GeneralRe: OPENXML() and performance Pin
Kjetil Svendsen10-Jul-08 2:34
Kjetil Svendsen10-Jul-08 2:34 
QuestionInternal Processor Error Pin
mehrnoosh9-Jul-08 21:58
mehrnoosh9-Jul-08 21:58 
AnswerRe: Internal Processor Error Pin
John_Adams10-Jul-08 1:34
John_Adams10-Jul-08 1:34 
GeneralRe: Internal Processor Error Pin
mehrnoosh14-Jul-08 22:17
mehrnoosh14-Jul-08 22:17 
QuestionConvert Decimal into Date Query?? Pin
obarahmeh9-Jul-08 20:30
obarahmeh9-Jul-08 20:30 
AnswerRe: Convert Decimal into Date Query?? Pin
Paddy Boyd9-Jul-08 20:56
Paddy Boyd9-Jul-08 20:56 
AnswerRe: Convert Decimal into Date Query?? Pin
Ashfield9-Jul-08 21:07
Ashfield9-Jul-08 21:07 
GeneralRe: Convert Decimal into Date Query?? Pin
obarahmeh9-Jul-08 22:35
obarahmeh9-Jul-08 22:35 
GeneralRe: Convert Decimal into Date Query?? [modified] Pin
Ashfield10-Jul-08 1:27
Ashfield10-Jul-08 1:27 
GeneralRe: Convert Decimal into Date Query?? Pin
obarahmeh10-Jul-08 2:02
obarahmeh10-Jul-08 2:02 
GeneralRe: Convert Decimal into Date Query?? Pin
Ashfield10-Jul-08 9:22
Ashfield10-Jul-08 9:22 
AnswerRe: Convert Decimal into Date Query?? [modified] Pin
leoinfo10-Jul-08 2:44
leoinfo10-Jul-08 2:44 
GeneralRe: Convert Decimal into Date Query?? [modified] Pin
obarahmeh12-Jul-08 21:46
obarahmeh12-Jul-08 21:46 
Questionhow to use index? very simple i want some basic information........... Pin
Shaik Haneef9-Jul-08 20:27
Shaik Haneef9-Jul-08 20:27 
AnswerRe: how to use index? very simple i want some basic information........... Pin
Paddy Boyd9-Jul-08 20:54
Paddy Boyd9-Jul-08 20:54 
AnswerRe: how to use index? very simple i want some basic information........... Pin
Ashfield9-Jul-08 21:13
Ashfield9-Jul-08 21:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.