it's slow to run ado???
the following is my script :
var conn,rs:Variant;
begin
conn := CreateOleObject('ADODB.Connection');
conn.ConnectionString :='Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DB_Service;Data Source=localhost';
conn.Open;
rs := conn.Execute('select name from web_user');
rs.MoveFirst;
while not (rs.EOF = True) do
begin
Showmessage(rs.Fields('name').value);
rs.MoveNext;
end;
end.
but it's so slow while runing!
what probleam about it??????????
var conn,rs:Variant;
begin
conn := CreateOleObject('ADODB.Connection');
conn.ConnectionString :='Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DB_Service;Data Source=localhost';
conn.Open;
rs := conn.Execute('select name from web_user');
rs.MoveFirst;
while not (rs.EOF = True) do
begin
Showmessage(rs.Fields('name').value);
rs.MoveNext;
end;
end.
but it's so slow while runing!
what probleam about it??????????
Comments
"File name=c:\link.udl" ,running speed is slowly too.