adodb performance EXCEL VBA vs vbscript

[RAYLWARD102]

I have a rather large query, containing a table join that returns approximately 80k rows; executing this query via excel VBA seems to result in a minute or longer of processing. I don’t have the same speed issues when returning 5-10000 rows in excel; just the one that’s returning 80k rows. I replicated my VBA adodb connections to a vbscript and wonder why the vbscript can return 80k rows in about 3seconds. Big difference in timing 1min vs 3seconds. I assure you, I’m invoking adodb the same ways in VBA vs vbscript; promis it has nothing to do with how I coded it. Any idea’s as to why this is?

 

[Kyle123]

Why don’t you just query it? Is your database really small?

 

[Fazza]

Or use the/a recordset. It even has methods that are OK for simple finds/filtering

 

[RAYLWARD102]

/a recordset methood; care to elaborate what that' about?

 

[Fazza]

suggest you google

for example https://docs.microsoft.com/en-us/of...esktop-database-reference/filter-property-ado