how to remain open a adodb.recordset for fast execution of bulk queries

[Pelukini]

I have to run a bulk number of sql select queries in vbscript on database. for this I create a database connection with name DBConnection and a record as belowset rsWrk = Server.CreateObject("ADODB.Recordset")Now I have to run bulk number of select queries and then have run them like belowrsWrk.Open Sql, DBConnectionand after this I close this within the loop as belowrsWrk.Closewhat I am thinking, to remain open this recordset and just set the sql query in each iteration. So, can any body suggest me how can I do this as the syntax is to set sql query at the time of open recordset or any other way for fast execution of the all queries.I am new to vbscript