Bill, To the best of my knowledge when you create temporay tables RBase creates a whole slew of SYSTMP tables to handle this event
When creating a temporary table/view, the following temporary System Tables are also created: ·SYSTMP_COMMENTS ·SYSTMP_CONSTRAINTS ·SYSTMP_DEFAULTS ·SYSTMP_RULES ·SYSTMP_SERVERS ·SYSTMP_TRIGGERS ·SYSTMP_VIEWS ·Temporary tables/views were first introduced in R:BASE 6.1 (July 1997). to handle this I believe the system creates one or more operating system files in a temporaty directory. You may need to indicate to anti-virus to exclude those files. Jim Bentley, American Celiac Society 1-504-737-329 3 ________________________________ From: "[email protected]" <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, January 29, 2014 7:49 AM Subject: [RBASE-L] - Re: Slooow data entry Manuel, The exe and rx* files are excluded from anti-virus. Thanks, Bill -------- Original Message -------- >Subject: [RBASE-L] - Re: Slooow data entry >From: "md" <[email protected]> >Date: Tue, January 28, 2014 9:47 pm >To: [email protected] (RBASE-L Mailing List) > > >Bill, > Can you exclude your compile .EXE file from your anti-virus? >Excluding your compiled EXE file will also expedite the loading process. >Hope it helps! >Manuel >M|D Enterprises > > >From:[email protected] [mailto:[email protected]] On Behalf Of Bill Eyring >Sent: Tuesday, January 28, 2014 4:00 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: Slooow data entry > >Javier, > >Client has full version on a computer other than the one generating the >problem. Tracing it in the full version found no delay problem. I am having >their IT people check out the network card and cabling on the problem computer >to see if that is the issue. > >Many thanks, > >Bill >From:[email protected] [mailto:[email protected]] On Behalf Of Javier Valencia >Sent: Tuesday, January 28, 2014 5:17 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: Slooow data entry > >I understand you are using a compiled application, but have you tried tracing >the process with the full version from a workstation and seeing where it is >getting delayed? > >Javier, > >Javier Valencia, PE >O: 913-829-0888 >H: 913-397-9605 >C: 913-915-3137 > >From:[email protected] [mailto:[email protected]] On Behalf Of >[email protected] >Sent: Tuesday, January 28, 2014 3:43 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: Slooow data entry > >Nope. > >Thanks > >-------- Original Message -------- >>Subject: [RBASE-L] - Re: Slooow data entry >>From: "Dan Goldberg" <[email protected]> >>Date: Tue, January 28, 2014 11:46 am >>To: [email protected] (RBASE-L Mailing List) >>You have anything running on the keypress eep? >> >>Dan Goldberg >> >>From:[email protected] >>Sent:Tuesday, January 28, 2014 10:39 AM >>To:RBASE-L Mailing List >>Subject:[RBASE-L] - Re: Slooow data entry >>Albert, >> >>I use C:\Temp as my scratch directory. The temp table is created in the menu >>choice before the form opens. I watched this directory and the scratch file >>erased when the form was exited, there were no leftover temp files. Even >>though I watched the temp files, the data entry was so slow. >> >>I have had the user exit the program and go back in and sometimes that makes >>the form go at normal speed, but not always. This is a compiled app and in my >>startup file I erase leftover temp files which works just fine. Maybe there >>are temp files somewhere else mucking things up ? I'm scratching my head on >>this one. >> >>Bill >> >>-------- Original Message -------- >>>Subject: [RBASE-L] - Re: Slooow data entry >>>From: Albert Berry <[email protected]> >>>Date: Tue, January 28, 2014 10:46 am >>>To: [email protected] (RBASE-L Mailing List) >>> >>>Just a thought Bill: Where is the temporary table being created? Does that >>>directory have a huge number of files in it? I have to clean out my temp >>>directories fairly often using Win 7 Pro. For R:Base uses, I have in the >>>past sometimes used a specific directory just for the temporary R:Base >>>files. >>>On 1/27/2014 3:55 PM, Bill Eyring wrote: >>>Ok so I have a compiled app running on a server using the latest and >>>greatest. >>>> >>>>When the user opens a particular form based on a temporary table, data >>>>entry becomes very slow. >>>> >>>>It starts in the first field of the form.(there are only 2 fields to enter >>>>data into). >>>> >>>>The user starts typing in data and after several seconds the data finally >>>>appears in the field. >>>> >>>>I have never seen this before and I'm hoping someone has some blues clues >>>>as to why. The computer UAC is set to lowest level. All other aspects of >>>>the program work fine. >>>> >>>>Workstation is running Windows 7 PRo with plenty of RAM and disk space. I >>>>tested the program on another network and it ran as expected. I am baffled. >>>> >>>>Thanks, >>>> >>>>Bill Eyring >>>
