Using the Windows login table seems to be REALLY slow ???

Dean_Axon · 2009-07-01

Hi All;

I am trying to use the windows Login table in a form (Table 2000000054) but it seems to take ages to return all the windows users

.

I don't think that all is lost as when you do "Tools>>Security>>Windows Logins" this uses the same table and is super fast

my question is this......

Dows anyone know how this speed has been achieved or have any solutions/suggestions n how I can make it faster for my own form ?

For completeness I am using Native DB, Client and Server v4 sp3.

MTIA.

Dean

David_Singleton · 2009-07-01

It could be a lo of things, but one that I have seen often is an issue with BDCs or where the domain is supported some way across a WAN. I had a really bad situation once where the client had their BDC at a remote location, and had the issue you mention. Taking BDC off line fixed it (temporarily of course). In the end we added the User name Text field to the table and had a routine that populated it once a week, and used that field instead.

Dean_Axon · 2009-07-01

Hi David,

all servers are in the same building so running across the LAN.

BTW, when I say slow, I mean 20-30 seconds not tens of minutes.

In the NAV form mentioned previously, it takes about 3 seconds and I can scroll quite happily up and down which I what I want to replicate in my own form.

Thanks

Dean

Belias · 2009-07-01

MAYBE the difference is that you have to calculate an extra flowfield (name) which is not calculated in the tools>security>...
try to create a form with wizard for table 2000000054 and...
first: add to the view only "ID" field
second: add the "name" field, too to the form and see what happens.

Dean_Axon · 2009-07-01

Hi Belias,

I did think of that too and created a form with just the "ID" field, still slower that the security form though ](*,)

Maybe I just have to live with it ?

Dean

Using the Windows login table seems to be REALLY slow ???

Comments

Categories