Fetchdata slow
Posted: Tue Oct 01, 2019 10:40 am
Hi,
I have some problem with fetchdata cursor created in SQL Express++, and as driver used VFP ODBC driver for DBF database type Visual Foxpro.
When one user open table, fetchdata work good. When open table other user, fetchdata is slow much slow.
But important is that when other user close table, fetchdata stay slow to time when user restart program.
It is similarly as when use DBF / CDX files in classic system in network but here this effect stay also when all users logout from table.
What s wrong ? Can be to table stay "opened" or ODBC driver hold table as open however application is closed ?
I know this is not problem with eXpress++, but if anybody have some advice ...
I do not find some solution how use true client server system for about 80 offices because it is not real install SQL server on their local servers. This is cause why I still use VFP ODBC driver that is installed on their Windows because need install some else
Sybase ALS/ADS I haven't been able to make it work ... and with MySQL is some problems on WIndows 2012 server.
I have some problem with fetchdata cursor created in SQL Express++, and as driver used VFP ODBC driver for DBF database type Visual Foxpro.
When one user open table, fetchdata work good. When open table other user, fetchdata is slow much slow.
But important is that when other user close table, fetchdata stay slow to time when user restart program.
It is similarly as when use DBF / CDX files in classic system in network but here this effect stay also when all users logout from table.
What s wrong ? Can be to table stay "opened" or ODBC driver hold table as open however application is closed ?
I know this is not problem with eXpress++, but if anybody have some advice ...
I do not find some solution how use true client server system for about 80 offices because it is not real install SQL server on their local servers. This is cause why I still use VFP ODBC driver that is installed on their Windows because need install some else
Sybase ALS/ADS I haven't been able to make it work ... and with MySQL is some problems on WIndows 2012 server.