Database data Versus External FSO

[vbnew]

Guys,

Can you guys tell me which method is the faster method ....

All i want is the total number of files within the root folder and its subsequent subfolders ....

When the data become voluminous in the database , it seems to be slow in retrieving the information as mentioned above....

but when i use the FSO and perform recursion , it seem to be much faster than the database method....

one thing i am not sure here, is the below statement
cnn.execute("insert blah blah blah")
when executed, the process got to wait until it is done? before proceed to next line of code?

[McGenius]

I couldn't quite understand what's FSO (in your context) has got to do with database but to answer your second question about executing SQL statement such cnn.execute("insert blah blah blah") I would say YES, program will delay until connection get respond back from DB.

[vbnew]

using the
"rst" style of inserting record
Versus
"cnn.execute"

which is faster?