pcsoft.us.windevCopyright 2026, PC SOFT17 Jul 2017 16:23:00 Z16 Jul 2017 09:28:00 ZHi, just a question: looking at performance, is a simple key in a big file (10 - 50 gigabytes) much better than a key with a link to another file? And if, at about which percentage would you estimate is the latter being worse? I'm pondering the idea of not to make seldom-used links (just for statistics) and update any changed values in the file just before running the statistics. Is it worth it? Would you recommend to do so?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61788/read.awp17 Jul 2017 16:23:00 ZHi guenter, It's difficult to say how much just with this info. The only way i know is by testing. In the read operation t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61788/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61788/read.awpQuestion about Key vs Key+Link in Analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61791/read.awp17 Jul 2017 16:05:00 ZHi Paulo, thank you! I took it for granted that there would be a degradation of performance by adding links. My question stil…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61791/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61791/read.awpQuestion about Key vs Key+Link in Analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61787/read.awp17 Jul 2017 15:29:00 ZThe main problem can be with the integrity constraints. If you have a lot of constraint when you update/delete one records the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61787/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61787/read.awpQuestion about Key vs Key+Link in Analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61786/read.awp17 Jul 2017 14:02:00 ZHi again I cannot say for sure that it would or wouldn't. I can only say that I have never noticed a difference and never had…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61786/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61786/read.awpQuestion about Key vs Key+Link in Analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61780/read.awp17 Jul 2017 07:10:00 ZHi Fabrice, it's HFSQL C/S. While adding new file items to an existing analysis and application I thought about the luxury to…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61780/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61780/read.awpQuestion about Key vs Key+Link in Analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61776/read.awp16 Jul 2017 22:24:00 ZHi Guenter, first, it probably depends on the DB used. Second, I have never have a performance problem due to links, so ma…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61776/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61759-question-about-key-key-link-analysis-61776/read.awpQuestion about Key vs Key+Link in Analysis