Database set-up/ideas

[photonbuddy]

Hi All,

I am writing a script that will need to store a large (possibly several thousand) number of filenames, with their size, and a couple of other flags.

Just wondering what the best solution to this would be.

I could just write them out to a standard text file, but that would make it much slower when updating information in the database.

Any ideas/suggestions would be greatly appreciated.

[flyingboz]

I am writing a script that will need to store a large (possibly several thousand) number of filenames, with their size, and a couple of other flags.

Just wondering what the best solution to this would be.

"best" is a highly subjective term.

Straight text is slow but straightforward to code, but a database has its own overhead to consider, plus you lose the ability to just read your data directly.

The Ini* functions would give you everything you need to store your values and variables in an easy to read format.

If you want to go to a structured format, you can consider XML or the database of your choice, either manually or using COM interfaces.

[Valuater]

i agree with flyingboz

additionally... this is a format i find usefull

filename.csv

1,File.txt,2/15/2005,1545 bytes,by autoit

this is comma delimited

is recognized and can be read & sorted by microsft excel

in autoit you can use this idea wirth stringsplit

$days = StringSplit("Sun,Mon,Tue,Wed,Thu,Fri,Sat", ",")
;$days[1] contains "Sun" ... $days[7] contains "Sat"

for $x = 1 to $days[0]
    MsgBox(0,"test", " The Day is " & $days[$x] & "  ")
Next

for a whole file you can use read to array

just some ideas

8)