Hello Everyone,

I am having an issue I don't know how to resolve. I am querying a database and making updates as I go along. when I first start the application it runs so fast but after about 5-10 minutes it starts to slow down to a snail's crawl. it's horrible. anyone have any suggestions as to how to prevent this?

This is a snippet of code:

m_daDataAdapter = New OleDb.OleDbDataAdapter("Select * From Word_Verse where Word = '" & MakeSQLSafe(strWord) & "' and VersePart = '" & MakeSQLSafe(strTempVerse) & "' and Book = '" & strBook & "'", m_cnADONetConnection)
m_cbCommandBuilder = New OleDb.OleDbCommandBuilder(m_daDataAdapter)
m_dtWordVerse.Reset()
m_daDataAdapter.Fill(m_dtWordVerse)


Where it's getting stuck or slowing down each time is on this line:
m_daDataAdapter.Fill(m_dtWordVerse)

I've tried resetting it but that didn't help I'm not sure what the issue is.

Any help would be great.

Thank you

Mythos