On 21 Jul 2011, at 3:29pm, Alok Singh wrote:
> Dim tx = cons.BeginTransaction()
Sorry but you're using a library I'm not familiar with. Judging from what you
wrote the first time I'd think more like
mycommand.CommandText = "BEING TRANSACTION"
mycommand.ExecuteNonQuery()
FOR z = 1 TO coun
*You mean this as follows as i written, please review it, its all still
slow..*
**
*Option 2:*
cons.Open()
dim z as integer
Dim mycommand As SQLiteCommand = New SQLiteCommand(cons)
Dim myparam As SQLiteParameter = New SQLiteParameter
On 21 Jul 2011, at 2:28pm, Alok Singh wrote:
> I am trying to Insert values into New Table "Ticket" from
> Table1,Table2,Table3 and Table4 with the following Query but its taking alot
> of time to insert values in new table.
> VB.NET + SQLITE using ADO.net connection (
Before your for INSERT com
Hi Sqlite Team,
I am trying to Insert values into New Table "Ticket" from
Table1,Table2,Table3 and Table4 with the following Query but its taking alot
of time to insert values in new table.
VB.NET + SQLITE using ADO.net connection ( Its having 25k+ rows)
*Option 1:*
4 matches
Mail list logo