... size Average table size (nr of rows) Biggest table size (nr of rows) Lan and / or Wan Nr of users Concurrent use (new additions by others) and locking Does app use ? Relations Scopes Filters Indexes with UDFs Locks Transactions do you use ado or sql directly through for example adofuncs.prg ...
With adordd with SET ADO FORCE LOCK ON no other user or other app (using clipper compatible locking) can alter the table lock or exclusive or record locked hold by you.
With this set ON the FILE LOCK, RECORD LOCK, EXCLUSIVE USE are guaranteed.
... before staff got in til just before the server backup started in the evening. That task went through and opened every .dbf I had effectively locking out anyone using the FoxPro interpreter from making any ( back door ) changes to my files, but it would still allow staff to use FoxPro to make ...
... that I use with DBFs. Since we can use both SQL tables and DBFs in the same app, I am thinking I can continue to use the same DBF which allows locking and thus is a simple solution. I also have a database class that has auto-incrementing using the above table, so I can solve the SQL auto-increment ...
... locks record by record. It would seem proper to COPY TO exclusively. With the APPEND FROM, possibly there could be a programming option to set the locking interval; x records or all records. Like I mentioned in a previous post, my calculations were that it would take about 12 hours to append a ...
... TO method but it still took 16 minutes and 42 seconds. So, it is not significantly faster that APPEND FROM. I think the speed issue has to do with locking. One reason is that I found that you have to force locking on or the APPEND FROM will crash at some point (unless maybe there are only a very ...
OK, it's not the manifest constant, it seems to be line 117 of TRYADORDD.PRG //CONTROL LOCKING IN ADORDD FOR BOTH TABLE AND RECORD DONT PUT FINAL "\" SET ADO LOCK CONTROL SHAREPATH TO "D:\WHATEVER" RDD TO "DBFCDX" I changed the "D:\WHATEVER" ...
... lock. When you request a lock ADORDD seeks the tablename+record you are using in SQL and if it finds it tries to lock it if not append a new one locking it. Since the locking its done by the rdd if station goes down the lock will be released. You can even delete the file exiting your app to avoid ...
Thanks Lucas, I have set LOCK OFF as your recommendation. It works now. Hello, Please set SET ADO FORCE LOCK OFF. So MySQL will do the locking. SET ADO DEFAULT RECNO FIELD TO "HBRECNO" SET AUTOPEN OFF //ON //might be OFF if you wish //SET AUTORDER TO 1 // first index opened ...
Hello, Please set SET ADO FORCE LOCK OFF. So MySQL will do the locking. This feature was a special situation for Antonio´s customer. So, the settings will be: SET ADO DEFAULT RECNO FIELD TO "HBRECNO" SET AUTOPEN OFF //ON //might be ...
... SERVER TO "localhost" ENGINE TO "MYSQL" USER TO "adordd" PASSWORD TO "" //control locking in adordd for both table and record dont puT final \ SET ADO LOCK CONTROL SHAREPATH TO "D:\WHATEVER" RDD TO "DBFCDX"//dont ...
... with the actual application with ADS and passed all trials. This app with adordd its now being tested intensive on concurrent access to check locking scheme and exclusive use. Will report results end next week. With adordd you can migrate immediately to any SQL server although all the trials ...
... with the actual application with ADS and passed all trials. This app with adordd its now being tested intensively on concurrent access to check locking scheme and exclusive use. Will report results end next week. Lucas DeBeltran helped a lot with his trials on his app and with his ideas. Antonio ...
David I decided several years ago to migrate all my .dbf's to either Ms Access (.mdb) or MS Sql Server using Ado. All opportunistic locking issues, SMB problems and network slowness Immediately Stopped, Vanished. To Me it was simpler to migrate my back end to SQL than to have to deal with ...
... records in the several tables and replace values Lets say a another user add a line to an order before its locked. When I initiate transaction locking the order that new record does not exist in my set yet. Thus will not be taken in account in my transaction. Dont you think this is a potential ...