>I have a form that inserts a couple of million records into a table from a text file. This process seems to get slower and slower the longer it runs.
>
>I would like to delete the indexes on this table before reading in the data. Hopefully this will speed thinks up.
>
>I found the delete tag command that actually deletes the cdx file. Is there a way to recreate these indexes programmatically when everything is done. I looked at the index command, but I don't think this will work because I need on of the indexes to be primary.
>
>Is there another way to do this?
>
>Thanks
>
>Pat Murphy

Check my site... I may have just what you need. www.waynemyers.com... under the code link.

HTH