Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping Through A Recordset
Couple of thoughts.
What cursor are you using. ForwardOnly is by far the most efficient rs.Open src, cnn, adOpenForwardOnly Secondly, you could try do the selection with a recordset filter rather than in the SQL. The SQL query should be considerably faster, but you will need to test it to see whether the recordset filter is quicker than a query select. Finally, although I haven't tried it myself to check if it is more efficient, you could load the recordset into an array suing the GetRows method, and then loop through the array aryData = GetRows(src) -- HTH are you using Bob Phillips "ibeetb" wrote in message ... I am looping through a recordset but it is taking FOREVER. It is a DB field that I am trying to collect a Disitinct list from. Here is the code: By the way, this code is tunning in Excel using ADO... By the way, there are a total 0f 55000 records to loop through. Anyway I can make this faster. It takes 5-6 minutes to create a distinct recordset 'Fills the Teams list box with available team names src = "SELECT DISTINCT public.tts_time_weekly_report_display.team_name " src = src & "FROM public.tts_time_weekly_report_display " src = src & "WHERE public.tts_time_weekly_report_display.tts_time_wee k_worked '12/31/2002' " rs.Open Source:=src, ActiveConnection:=cnn Do While Not rs.EOF frmTeams.lstTeam.RowSource = rs frmTeams.lstTeam.AddItem rs.Fields("team_name").Value rs.MoveNext Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
query a recordset | Excel Discussion (Misc queries) | |||
return recordset | Excel Discussion (Misc queries) | |||
create recordset from csv file on web | Excel Programming | |||
ADO slow recordset getrows | Excel Programming | |||
ADODB Recordset | Excel Programming |