This widget could not be displayed.
Created:
Dec 7, 2010 04:26 PM
| Last Modified:
Dec 7, 2010 1:26 PM
(26002 views)
| Posted in reply to message from pmroz 12-07-2010
> Here's another way. I don't know if it's any
> faster.
Well I made a table with 6 columns and 100,000 rows and the For solution took about 1 second and the direct select took "0" seconds.
When I increased the number of rows to 1,000,000 then the For solution took 11 or 12 seconds and the direct select took 3 seconds.
So on my pc running winXP using this particular table the direct select is about 4 times faster but you would need a really large table to notice the difference.
Michael