pcsoft.us.windevCopyright 2026, PC SOFT26 Oct 2014 22:48:00 Z18 Oct 2014 09:59:00 ZHi We have 1 client where access to data is awfully slow. For example a lookup which takes 1.5 seconds on my machine takes 59 seconds on theirs. This is accessing a data table with just over 25,000 records and returning 119. We are using a query, joining 2 other tables. Data is on SSD in both cases. They are running Server 2008 whereas we are using Win 7. I ran the comparison when no-one else was logged in at all and there was nothing else running on either machine. Looking at the HFCS activity log the main difference is number of access to the disk in read-only (20,965 on mine, 243,054 on theirs) and Bytes read from the disk (6.4m on mine, 59m on theirs). We've reindexed/optimized the indexes but no change. Other apps run fine apparently (although ours is probably the only data intensive one they have so that probably doesn't mean a real lot). Any ideas on where we should be looking would be much appreciated. Thanks David30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48668/read.awp26 Oct 2014 22:48:00 ZIt looks like the firewall and network security config issue, you may just try using a simple win7 prof running on the same netw…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48668/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48668/read.awpPainfully slow HFCS Accessguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48662/read.awp25 Oct 2014 18:59:00 ZDavid, see if you have in the Windows Processes and Services some kind of Bank Security Application running in the background li…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48662/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48662/read.awpPainfully slow HFCS Accessguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48576/read.awp21 Oct 2014 02:38:00 ZChecked anti-virus but it's not that either unfortunately. They have a spare server so we're looking at moving the database o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48576/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48576/read.awpPainfully slow HFCS Accessguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48553/read.awp19 Oct 2014 20:39:00 ZThanks Peter I should have mentioned that I had bumped up the cache size with no appreciable difference. Hadn't thought of anti…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48553/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48553/read.awpPainfully slow HFCS Accessguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48548/read.awp18 Oct 2014 10:37:00 ZHi David, 2 things: 1) What is the setting on the HFCS for caching the indexes? See HF Control Center settings. 2) Is ther…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48548/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48545-painfully-slow-hfcs-access-48548/read.awpPainfully slow HFCS Access