pcsoft.us.windevCopyright 2026, PC SOFT9 Feb 2018 12:45:57 Z9 Feb 2018 07:56:05 ZI have a very large set of web, desktop/server, and mobile applications all built around a LARGE database primarily in HFCS. I am trying to address performance issues due to some of the tables being huge. I originally tried to use some logic to move old records to an archive table, but that was way to slow. I have now mode copies of the files (FIC and NDX) and mapped to a new name for archive. I can't seem to find a way to delete/purge the old records from the production table that is at all practical. The largest table is 155GB FIC, not including the NDX. We've tried to use queries to delete the old records but it is painfully slow. I need to delete about 15 Million records. It took 3 hours to delete 8,000 last time we tried. I also noticed the file size is not reduced on the delete. I assume we will have to reindex to have that happen, which would take a ridiculous amount of time as well. Anyone have any suggestions,, best practice for how to handle this? We do not have an option to take any of the "current" data offline (about 20 Million records in this particular file). Stephen30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64495-help-deleting-archiving-large-hfcs-databases/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)myerssjpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64495-help-deleting-archiving-large-hfcs-databases-64501/read.awp9 Feb 2018 12:45:57 Zthanks for the response. I've never messed with Crossed records. I wonder if cross would be faster than delete. Since it l…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64495-help-deleting-archiving-large-hfcs-databases-64501/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64495-help-deleting-archiving-large-hfcs-databases-64501/read.awpHelp deleting/archiving LARGE HFCS DatabasesJoey Dielemanpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64495-help-deleting-archiving-large-hfcs-databases-64497/read.awp9 Feb 2018 10:49:34 ZHi Stephen, I do not have experience with such bit databases, I do have with databases with million records. Maybe you alread…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64495-help-deleting-archiving-large-hfcs-databases-64497/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64495-help-deleting-archiving-large-hfcs-databases-64497/read.awpHelp deleting/archiving LARGE HFCS Databases