OK, I hope this question isn't too out of left field... I am building a utility (which will be used infrequently, I'm sure) that will allow the user to build an index without having to know the syntax of CREATE INDEX statament. Since it can take a long time to build an index, I'm also contemplating a way to provide the current build status, on request, to the user. When I create indexes "manually" I check the status by repeatedly getting a directory listing to look at the size and timestamp of the files. If they keep changing, then I know the the process is still alive and the index is still building. I also am aware that for indexes that are in the process of building, the TYPE column in SYSINDEX is lower case for that row.
I guess my question is a general one for guidance... Is simply automating the "methodology" of checking the progress of file sizes and time stamps the best way to go, or is there a different approach that someone might suggest?
Thanks
I guess my question is a general one for guidance... Is simply automating the "methodology" of checking the progress of file sizes and time stamps the best way to go, or is there a different approach that someone might suggest?
Thanks