G
Guest
Hi ! It seems to me that when I grow a XML database in size, a certain
..select call fails, although the records are there indeed.
This is the code :
Dim dsAcesso as New DataSet
dsAcesso.CaseSensitive = False
Dim FsXML As New FileStream("Test.xml", FileMode.Open)
Dim xtrXML As New XmlTextReader(FsXML)
dsAcesso.ReadXml(xtrXML, XmlReadMode.InferSchema)
xtrXML.Close()
FsXML.Close()
'
Dim dtOpcaoPorItem As New Data.DataTable
Dim maOpcaoPorItem() As Data.DataRow
dtOpcaoPorItem = mdsAcesso.Tables("OptionsByItem")
maOpcaoPorItem = dtOpcaoPorItem.Select("Supplier=4 AND Item='666'", "MRU",
Data.DataViewRowState.CurrentRows)
'maOpcaoPorItem.GetUpperBound(0) returns -1 when there are too many records !
Any hint ? I used dataview but its performance is really bad...
Thanks !!
..select call fails, although the records are there indeed.
This is the code :
Dim dsAcesso as New DataSet
dsAcesso.CaseSensitive = False
Dim FsXML As New FileStream("Test.xml", FileMode.Open)
Dim xtrXML As New XmlTextReader(FsXML)
dsAcesso.ReadXml(xtrXML, XmlReadMode.InferSchema)
xtrXML.Close()
FsXML.Close()
'
Dim dtOpcaoPorItem As New Data.DataTable
Dim maOpcaoPorItem() As Data.DataRow
dtOpcaoPorItem = mdsAcesso.Tables("OptionsByItem")
maOpcaoPorItem = dtOpcaoPorItem.Select("Supplier=4 AND Item='666'", "MRU",
Data.DataViewRowState.CurrentRows)
'maOpcaoPorItem.GetUpperBound(0) returns -1 when there are too many records !
Any hint ? I used dataview but its performance is really bad...
Thanks !!