VRB RunQuery in datacontrol

[Damon Pillinger]

Hi Serge,

Last one I promise.
Can you have a look at the code of the RunQuery for a datacontrol.
100 queries take 33 seconds whereas the same using SQLselect take about
1 second.


  'dataControl1 run query
  ts=ticks
  dataControl1.sqLQuery="Select * from Test"
  for i= 1 to 100
    dataControl1.runQuery
  next

  
Is there some way you can improve this feature?
Many Many thanks

Best Regards

Damon L. Pillinger
Jensen 2005 by Daisychain
www.daisychain.no-ip.biz
Phone : 03 9532 1220
Fax : 03 9532 1280