e, but the entire
group is usually not completely changed.
mike
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Monday, November 03, 2008 9:31 AM
To: cf-talk
Subject: RE: LDAP Query Performance question
See, I'm doing the opposite. I'm getting a list of
s to the
AD for each account. I'm definitely looking into this AD/SQL linking
which I had never heard of before. Thanks for the help!
John
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Monday, November 03, 2008 10:27 AM
To: cf-talk
Subject: RE: LDAP Query
;t hurt a thing.
Mike
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Monday, November 03, 2008 9:19 AM
To: cf-talk
Subject: RE: LDAP Query Performance question
Mike-
When you do this is this a loop that runs 5500 queries or 1 query that
updates 5500 records? Just c
: LDAP Query Performance question
Oh, by the way, regarding my earlier message. We have about 5,500
accounts that I update on a daily basis. Performance isn't really an
issue, however, I have plans to cut this down from taking several
minutes, to just a few dozen seconds.
Mike
-Ori
My point exactly :)
On Fri, Oct 31, 2008 at 3:17 PM, Dawson, Michael <[EMAIL PROTECTED]>wrote:
> AD can handle 32,001
>
> ;^)
>
> -Original Message-
> From: Shannon Peevey [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 31, 2008 3:06 PM
> To: cf-
AD can handle 32,001
;^)
-Original Message-
From: Shannon Peevey [mailto:[EMAIL PROTECTED]
Sent: Friday, October 31, 2008 3:06 PM
To: cf-talk
Subject: Re: LDAP Query Performance question
LDAP is optimized for reading, so I would assume that tens of thousands
of requests per second
e
>
> -Original Message-
> From: Burns, John D [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 31, 2008 12:03 PM
> To: cf-talk
> Subject: RE: LDAP Query Performance question
>
> It's just a nightly task but it may have 300-400 results each time it
> runs. I
ohn D [mailto:[EMAIL PROTECTED]
Sent: Friday, October 31, 2008 12:03 PM
To: cf-talk
Subject: RE: LDAP Query Performance question
It's just a nightly task but it may have 300-400 results each time it
runs. I don't think it'll bring down the house or anything it just
brought up the ques
John D [mailto:[EMAIL PROTECTED]
Sent: Friday, October 31, 2008 11:26 AM
To: cf-talk
Subject: LDAP Query Performance question
I have a query of a SQL table that returns to me a bunch of usernames.
>From that, I need to query some information out of Active Directory for
each user. Right now I hav
ROTECTED]
Sent: Friday, October 31, 2008 12:51 PM
To: cf-talk
Subject: Re: LDAP Query Performance question
On Friday 31 Oct 2008, Burns, John D wrote:
> I have a query of a SQL table that returns to me a bunch of usernames.
> From that, I need to query some information out of Active Directory
f
On Friday 31 Oct 2008, Burns, John D wrote:
> I have a query of a SQL table that returns to me a bunch of usernames.
> From that, I need to query some information out of Active Directory for
> each user. Right now I have it looping over each row in the result from
Firstly, how many is a bunch, how
Here is a link to information about optimizing and profiling ldap queries to
AD:
http://robbieallen.com/downloads/RAllen_LDAP_Searching.ppt
On Fri, Oct 31, 2008 at 11:25 AM, Burns, John D <[EMAIL PROTECTED]> wrote:
> I have a query of a SQL table that returns to me a bunch of usernames.
> From th
I have a query of a SQL table that returns to me a bunch of usernames.
>From that, I need to query some information out of Active Directory for
each user. Right now I have it looping over each row in the result from
the SQL query and doing a separate LDAP query to the AD. This just
doesn't seem lik
-Oorspronkelijk bericht -
Van: "Martin Thorpe" <[EMAIL PROTECTED]>
Aan: "CF-Talk"
Verzonden: 4-5-06 18:25
Onderwerp: query performance help
>
> I am looking for some advice to speed this query
> up, or any database tips and tricks that I could
>
rry about a
dangling AND.
But again, I know nothing about Oracle
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Martin Thorpe [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 04, 2006 12:26 PM
To: CF-Talk
Subject: query performance help
Hello.
I am looking
Hello.
I am looking for some advice to speed this query up, or any database
tips and tricks that I could use to improve the performance of this
query. It is reading across 2 databases, this is required, there is
also an inner join from one table to itself I do not know if this hits
the perfo
Run a trace on that db saving the trace data to a file while you run your app then run
the index tunning wizard
-Original Message-
To: CF-Talk <[EMAIL PROTECTED]>
From: Jochem van Dieten <[EMAIL PROTECTED]>
Subject: Re: Need to optimise query performance
Date: Wed, 26 Ju
asp
http://www.swynk.com/friends/achigrik/UseCursor.asp#part_2
HTH,
-Original Message-
From: Vishal Narayan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 1:08 AM
To: CF-Talk
Subject: Need to optimise query performance
We are running our website on CF4.5 with Win 2K, IIS5 and SQL
Vishal Narayan wrote:
> 3. Performance tuning at DB level and database optimisation:
> I've already tried the following :
> - primary keys for all tables in use
> - indexes on all columns used for joins
> Is there anything else I can do towards performance tuning ? Could I use
> views to reduce
> Just a quick question - why would one write an Action page with the
> following bit of code for a insert select statement
>
> METHOD A:
>
> Insert into TblCustomer (CustomerId, Forename,Surname, CompanyName)
> SELECT tmpTblCustomer.CustomerId, tmpTblCustomer.Forename,
> tmpTblCustomer.Surn
Hi all,
Just a quick question - why would one write an Action page with the
following bit of code for a insert select statement
METHOD A:
Insert into TblCustomer (CustomerId, Forename,Surname, CompanyName)
SELECT tmpTblCustomer.CustomerId, tmpTblCustomer.Forename,
tmpTblCustomer.Surname
21 matches
Mail list logo
