Multi User Queries taking forever....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roman B. - 18 Jan 2006 07:02 GMT

We have 10 users using access XP 2002, accessing an access database with
about 300,000 records. currently it is taking about 6-8 minutes per lookup on
the database which resides on a windows 2003 server with 2 gigs of Ram. Is
this normal or is there something I can do to speed the lookups? My systems
are running windows XP SP2 with at least 512 megs ram with most close to a
gig a ram locally.

Reply to this Message

Van T. Dinh - 18 Jan 2006 11:54 GMT

(multiple replies in Queries newsgroup)

Please do not multipost the same question in different newsgroups. Please
see:

http://www.mvps.org/access/netquette.htm

Signature

HTH
Van T. Dinh
MVP (Access)

> We have 10 users using access XP 2002, accessing an access database with
> about 300,000 records. currently it is taking about 6-8 minutes per lookup
[quoted text clipped - 4 lines]
> are running windows XP SP2 with at least 512 megs ram with most close to a
> gig a ram locally.

Reply to this Message

Roman B. - 18 Jan 2006 14:42 GMT

Hey Van,

Thanks for the heads up, however I've posted in microsft newsgroups before
only to be told that I my question should be posted in another newsgroup.

Thanks I'll check out your link.

> (multiple replies in Queries newsgroup)
>
[quoted text clipped - 11 lines]
> > are running windows XP SP2 with at least 512 megs ram with most close to a
> > gig a ram locally.

Reply to this Message

Rick Brandt - 18 Jan 2006 14:59 GMT

> Hey Van,
>
> Thanks for the heads up, however I've posted in microsft newsgroups
> before only to be told that I my question should be posted in another
> newsgroup.

In that case you should crosspost rather than multi-post (to a reasonably
short list of groups). See link for explanation.

http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Van T. Dinh - 18 Jan 2006 15:11 GMT

If you read a few Microsoft Access newsgroups, you will notice that regular
respondents read and reply to posts in a large number of Access newsgroups.
Provide that your question is related to Access, I think you find, in
general, the same group of respondents who will reply to your question
regardless of the Access newsgroup you posted to.

OTOH, you can use cross-posting to make your question appearing in a number
of groups (max 3 newsgroups only, please) as Rick advised and you can check
all answers regardless of which newsgroup you want to look at.

Signature

HTH
Van T. Dinh
MVP (Access)

> Hey Van,
>
> Thanks for the heads up, however I've posted in microsft newsgroups before
> only to be told that I my question should be posted in another newsgroup.
>
> Thanks I'll check out your link.

Reply to this Message

Roman B. - 18 Jan 2006 17:55 GMT

Thanks ... Next Time I'll use the crossposting feature.

thanks again
roman

> If you read a few Microsoft Access newsgroups, you will notice that regular
> respondents read and reply to posts in a large number of Access newsgroups.
[quoted text clipped - 12 lines]
> >
> > Thanks I'll check out your link.

Reply to this Message