Y
Yair Cohen
hi all.
i use mysql as the db.
i use .net ado to run a select query to return a datatable:
something like this:
dim x as new dbdataadapter(".... select ...", cnn)
dim dt as new datatable
x.fill(dt)
return dt
' **
the probolem is, when i run this query on the db tool (i use control center
for mysql) the result come up in 0.5 seconds (3000 rows, 6 joins...) thats
grate, but in my program the line x.fill(dt) ( the build of the datatable)
takes neerly 30 seconds !!!!!
i never meet so huge difference.
what can i do to improve this ???
thanks, Yair
i use mysql as the db.
i use .net ado to run a select query to return a datatable:
something like this:
dim x as new dbdataadapter(".... select ...", cnn)
dim dt as new datatable
x.fill(dt)
return dt
' **
the probolem is, when i run this query on the db tool (i use control center
for mysql) the result come up in 0.5 seconds (3000 rows, 6 joins...) thats
grate, but in my program the line x.fill(dt) ( the build of the datatable)
takes neerly 30 seconds !!!!!
i never meet so huge difference.
what can i do to improve this ???
thanks, Yair