>>Keys and indexes are critical in RDBMS performance... you cannot really do
without them.
I Know. I was just going to save time, when I imported the data to the
table(s). But it still as to slow.
>>Are these like directory stats, a bit like that produced by "du" under
Unix/Linux?
Yep. I do a du on the filesystem, and then want to process data to find out
where to clean up.
Typical stuff you want to see, is what is the largest directories, and then
break them down to find the user (or subdir) that it will make the most
bennefit to contact ;-)
And I want the users themselves to find all directories they are responsible
for, and do some searching to find out where the problem is. If there is
any.
>>Are you ever going to want to search for entries spanning more than one
directory ('foo/bar') or partial directories ('oo')?
Yep. The structure is normally with the project at top, and then the users
below.
And since a filesystem may hold more than one project, I may find the
username in multiple directorie trees. e.g.
/proj/testproject/usr/kmi/mysrc/hhhh
And /proj/anotherproject/usr/kmi/mysrc/blablabla
>>You say the file contains 1,500,000 lines, correct? And you have to read
this once and process it?
Well, not once, since the data changes from day to day, I may need to do
this operation on a weekly basis,
>>You say the file contains 1,500,000 lines, correct? And you have to read
this once and process it?
Yep, the current filesize is 186.708.410 Bytes.
At first glance I said no chance this can be in memory at once, but I think
you are right that could be done. It has to be read over the network, but I
could save a local copy, and the simply process and delete files not needed.
If a selection is regretted, I could reread it from the local file. And
sorting? hmm can be done.
I will do a little testing.
Thanks a lot.
/Kaj
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
