Sign in to follow this  
Followers 0
photonbuddy

Database set-up/ideas

3 posts in this topic

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.

Share this post


Link to post
Share on other sites



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.


Reading the help file before you post... Not only will it make you look smarter, it will make you smarter.

Share this post


Link to post
Share on other sites

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)


NEWHeader1.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0