Max size of a directory

[Guest T. Valko]

Hi Folks!

 

From within Excel I generate simple text files (*.txt) and name them in

sequence: File1.txt, File2.txt, File3.txt, etc, etc.

 

The average size of one of these files is about 210 bytes.

 

I need to generate "a lot" of these files. Specifically, I need 2622 of

these text files.

 

My question is: can I put all 2622 of these files in a single directory?

 

What's the max size of a directory?

 

I haven't tried it yet. If I can do this it will make my life much easier!

 

--

Biff

Microsoft Excel MVP

[Guest Pegasus \(MVP\)]

Re: Max size of a directory

 

 

"T. Valko" <biffinpitt@comcast.net> wrote in message

news:e0r8oYi1IHA.5832@TK2MSFTNGP02.phx.gbl...

> Hi Folks!

>

> From within Excel I generate simple text files (*.txt) and name them in

> sequence: File1.txt, File2.txt, File3.txt, etc, etc.

>

> The average size of one of these files is about 210 bytes.

>

> I need to generate "a lot" of these files. Specifically, I need 2622 of

> these text files.

>

> My question is: can I put all 2622 of these files in a single directory?

>

> What's the max size of a directory?

>

> I haven't tried it yet. If I can do this it will make my life much easier!

>

> --

> Biff

> Microsoft Excel MVP

 

Yes, you can put all 2622 files into one folder. The limit

is "zillions" but file access will slow down to a crawl after

a few 100,000 files. For best speed I would not go above

10,000 files per folder.

[Guest Terry R.]

Re: Max size of a directory

 

The date and time was 6/24/2008 11:14 AM, and on a whim, T. Valko

pounded out on the keyboard:

> Hi Folks!

>

> From within Excel I generate simple text files (*.txt) and name them in

> sequence: File1.txt, File2.txt, File3.txt, etc, etc.

>

> The average size of one of these files is about 210 bytes.

>

> I need to generate "a lot" of these files. Specifically, I need 2622 of

> these text files.

>

> My question is: can I put all 2622 of these files in a single directory?

>

> What's the max size of a directory?

>

> I haven't tried it yet. If I can do this it will make my life much easier!

>

 

If your disk if formatted using NTFS, you won't hit the a limit. FAT32

had about 65k per.

 

A different limit is how bogged down Windows Explorer gets. The more

files in the directory, the longer it takes for Explorer to open. Get

too many, and Explorer will crash.

 

--

Terry R.

 

***Reply Note***

Anti-spam measures are included in my email address.

Delete NOSPAM from the email address after clicking Reply.

[Guest T. Valko]

Re: Max size of a directory

 

Pegasus (MVP)" <I.can@fly.com.oz> wrote in message

news:%23RsF$ji1IHA.5472@TK2MSFTNGP06.phx.gbl...

>

> "T. Valko" <biffinpitt@comcast.net> wrote in message

> news:e0r8oYi1IHA.5832@TK2MSFTNGP02.phx.gbl...

>> Hi Folks!

>>

>> From within Excel I generate simple text files (*.txt) and name them in

>> sequence: File1.txt, File2.txt, File3.txt, etc, etc.

>>

>> The average size of one of these files is about 210 bytes.

>>

>> I need to generate "a lot" of these files. Specifically, I need 2622 of

>> these text files.

>>

>> My question is: can I put all 2622 of these files in a single directory?

>>

>> What's the max size of a directory?

>>

>> I haven't tried it yet. If I can do this it will make my life much

>> easier!

>>

>> --

>> Biff

>> Microsoft Excel MVP

>

> Yes, you can put all 2622 files into one folder. The limit

> is "zillions" but file access will slow down to a crawl after

> a few 100,000 files. For best speed I would not go above

> 10,000 files per folder.

>

 

Great! This will save me from a ton of tedious, monotonus work.

 

Now I can just click a button and be done.

 

Thanks!

[Guest T. Valko]

Re: Max size of a directory

 

"Terry R." <F1Com@NOSPAMpobox.com> wrote in message

news:O$ktnni1IHA.1628@TK2MSFTNGP03.phx.gbl...

> The date and time was 6/24/2008 11:14 AM, and on a whim, T. Valko pounded

> out on the keyboard:

>

>> Hi Folks!

>>

>> From within Excel I generate simple text files (*.txt) and name them in

>> sequence: File1.txt, File2.txt, File3.txt, etc, etc.

>>

>> The average size of one of these files is about 210 bytes.

>>

>> I need to generate "a lot" of these files. Specifically, I need 2622 of

>> these text files.

>>

>> My question is: can I put all 2622 of these files in a single directory?

>>

>> What's the max size of a directory?

>>

>> I haven't tried it yet. If I can do this it will make my life much

>> easier!

>>

>

> If your disk if formatted using NTFS, you won't hit the a limit. FAT32

> had about 65k per.

>

> A different limit is how bogged down Windows Explorer gets. The more files

> in the directory, the longer it takes for Explorer to open. Get too many,

> and Explorer will crash.

>

> --

> Terry R.

>

> ***Reply Note***

> Anti-spam measures are included in my email address.

> Delete NOSPAM from the email address after clicking Reply.

 

The number of files will never exceed 2622. So I should be good to go!

 

Thanks!

 

--

Biff

Microsoft Excel MVP

[Guest Tim Slattery]

Re: Max size of a directory

 

"T. Valko" <biffinpitt@comcast.net> wrote:

>Hi Folks!

>

>From within Excel I generate simple text files (*.txt) and name them in

>sequence: File1.txt, File2.txt, File3.txt, etc, etc.

>

>The average size of one of these files is about 210 bytes.

>

>I need to generate "a lot" of these files. Specifically, I need 2622 of

>these text files.

>

>My question is: can I put all 2622 of these files in a single directory?

 

Yes.

>What's the max size of a directory?

 

If FAT32, you can have 64K entries in a directory. A file or

subdirectory with a name longer than 8.3 or containing spaces, commas,

or other non-standard characters will take from two to thirteen

entries (depending on length).

 

In the NTFS system there is no per-directory limit. There is a

per-partition limit, but you're not likely to get there.

 

--

Tim Slattery

MS MVP(Shell/User)

Slattery_T@bls.gov

http://members.cox.net/slatteryt

[Guest PhilHibbs]

Re: Max size of a directory

 

A word of warning to anyone else reading this thread, though, is that

with a *very* large number of files (hundreds of thousands, possibly

just tens of thousands), you get weird errors when issuing Command

Prompt commands in the directory. This is because you get short file

names generated that cause a file to match a pattern that it should

not if you only consider the long file name. So, if you do "dir 123*",

or "del 123*", then you might display or delete some files that do not

begin with 123.

 

Phil Hibbs.

[Guest Terry R.]

Re: Max size of a directory

 

The date and time was 6/24/2008 11:53 AM, and on a whim, T. Valko

pounded out on the keyboard:

> "Terry R." <F1Com@NOSPAMpobox.com> wrote in message

> news:O$ktnni1IHA.1628@TK2MSFTNGP03.phx.gbl...

>> The date and time was 6/24/2008 11:14 AM, and on a whim, T. Valko pounded

>> out on the keyboard:

>>

>>> Hi Folks!

>>>

>>> From within Excel I generate simple text files (*.txt) and name them in

>>> sequence: File1.txt, File2.txt, File3.txt, etc, etc.

>>>

>>> The average size of one of these files is about 210 bytes.

>>>

>>> I need to generate "a lot" of these files. Specifically, I need 2622 of

>>> these text files.

>>>

>>> My question is: can I put all 2622 of these files in a single directory?

>>>

>>> What's the max size of a directory?

>>>

>>> I haven't tried it yet. If I can do this it will make my life much

>>> easier!

>>>

>> If your disk if formatted using NTFS, you won't hit the a limit. FAT32

>> had about 65k per.

>>

>> A different limit is how bogged down Windows Explorer gets. The more files

>> in the directory, the longer it takes for Explorer to open. Get too many,

>> and Explorer will crash.

>>

>

> The number of files will never exceed 2622. So I should be good to go!

>

> Thanks!

>

 

Depends on your CPU, RAM, hard disk speed, etc. But I think you should

be okay.

 

--

Terry R.

 

***Reply Note***

Anti-spam measures are included in my email address.

Delete NOSPAM from the email address after clicking Reply.

[Guest T. Valko]

Re: Max size of a directory

 

I still love DOS!

 

--

Biff

Microsoft Excel MVP

 

 

"PhilHibbs" <snarks@gmail.com> wrote in message

news:24477087-4951-4948-83e3-1a1ac468e9c6@z72g2000hsb.googlegroups.com...

>A word of warning to anyone else reading this thread, though, is that

> with a *very* large number of files (hundreds of thousands, possibly

> just tens of thousands), you get weird errors when issuing Command

> Prompt commands in the directory. This is because you get short file

> names generated that cause a file to match a pattern that it should

> not if you only consider the long file name. So, if you do "dir 123*",

> or "del 123*", then you might display or delete some files that do not

> begin with 123.

>

> Phil Hibbs.