Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBC events - anyone used them?
Message
 
 
To
07/04/2005 13:22:06
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01002359
Message ID:
01002384
Views:
19
>>Hi everybody,
>>
>>I noticed, that our table rule UpdateUserAndTime() takes too much time. It calls another procedure called GetUserID(). I'm thinking, it would be nice to use some global var instead. But the problem is where we set this variable and release it. One of the ideas is to use DBC events.
>>
>>What would be your suggestions here?
>>
>>Thanks in advance.
>
>GetUserID takes only nanoseconds. However I too get it once in login form and store in oApp.oCurrentUser.
>Cetin

Thanks. We're thinking about having a switch to turn off the rule firing completely. Also in our tests for 100000 records it seems to be almost 3 times faster with using constant instead of GetUserID() in the replace command.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform