generate near table woes

KarenGreen

Recently I discovered this tool and love it.  I have used it many times.  Last week, it stopped working.

I have 2 files with almost a million points.
I run the Generate Near Table and I am hoping to identify all the points within a given distance.

Previously when I have done this, my files were about the same size, may be a bit bigger this time.
The table I created was a simple .dbf

But as of last week when I run it, the .dbf gets to just over 2gb and then just hangs.
So I changed the output to be a file geodatabase to avoid the file size limitations.
I reran the job.  I had 20gbs of space on they hard drive and it filled it completely.
So then I deleted a bunch of stuff and cleared up almost 100gb.
I reran the job several times and each time it fills up the hard drive.

There is not that much data to do this.
Anyone have any ideas what could be happening.

I am using 9.3.1.
I also upgraded to patch 2 today and tried it again but got the same results.

I have made my file size smaller and still I can not get it to run.

Any ideas?????????????
I love this tool, but it just does not want to work.

Thanks in advance.
Just Me

gpnobbir

Ok, I ran the tool with two point feature classes - each having half million points. It took hours to finish but didn't fill up the hard drive. The final size of the output gdb was 32 MB.

I have used 9.3.1 sp1 whereas you used 9.3.1 (final?).

What's the configuration of your machine? OS? RAM? HD?
My configuration is: XP sp3, 4 GB or RAM and 120 GB of HD.