Access XP and SQL very slow

msmcnewsxp

unread,

Aug 5, 2003, 11:35:39 AM8/5/03

to

any special tweaking i need to do to my SQL server to speed things up.
my home network is very simple - 6 port hub, one 1.8 gb server with gig of
RAM, on e XP pro workstation, one 2k, and one Me workstation. also DSL
modem on hub.
the XP machine performs any sort of data access very slowly when linked to
either SQL or another MDB on the network. the other boxes run faster.
any clues?
thanks,
mcnews

Vadim Rapp

unread,

Aug 5, 2003, 1:26:02 PM8/5/03

to

m> any special tweaking i need to do to my SQL server to speed things
m> up. my home network is very simple - 6 port hub, one 1.8 gb server
m> with gig of RAM, on e XP pro workstation, one 2k, and one Me
m> workstation. also DSL modem on hub.
m> the XP machine performs any sort of data access very slowly when
m> linked to either SQL or another MDB on the network. the other
m> boxes run faster. any clues?
m> thanks,
m> mcnews

I would check if it does not try to find the server on every step using
Internet DNS. Get off the internet, or better remove Internet dns and see if it
changes.

Also change the network library (client network utility) and see if makes a
difference.

Vadim

----------------------------------------
Vadim Rapp Consulting
SQL, Access, VB Solutions
847-685-9073

msmcnewsxp

unread,

Aug 5, 2003, 2:18:35 PM8/5/03

to

"Vadim Rapp" <v...@myrealbox.nospam.com> wrote in message
news:ObjCka3W...@TK2MSFTNGP10.phx.gbl...

> m> any special tweaking i need to do to my SQL server to speed things
> m> up. my home network is very simple - 6 port hub, one 1.8 gb server
> m> with gig of RAM, on e XP pro workstation, one 2k, and one Me
> m> workstation. also DSL modem on hub.
> m> the XP machine performs any sort of data access very slowly when
> m> linked to either SQL or another MDB on the network. the other
> m> boxes run faster. any clues?
> m> thanks,
> m> mcnews
>
>
> I would check if it does not try to find the server on every step using
> Internet DNS. Get off the internet, or better remove Internet dns and see
if it
> changes.
>

can't use interent without DNS server IP addresses.

> Also change the network library (client network utility) and see if makes
a
> difference.
>

only TCP/IP is enabled.

Vadim Rapp

unread,

Aug 5, 2003, 6:53:46 PM8/5/03

to

m> only TCP/IP is enabled.

so enable something else (on the server as well) and see if it makes
difference.

SF

unread,

Aug 6, 2003, 3:36:08 AM8/6/03

to

I have same problems. I uncheck the 'Enable Forwader' of the Server DNS, it
work fine.

SF

"msmcnewsxp" <mcou...@mindspring.com> wrote in message
news:#aaN933W...@TK2MSFTNGP12.phx.gbl...

Steve

unread,

Aug 8, 2003, 11:12:57 AM8/8/03

to

This sounds like a network issue, not a SQL issue.

Can you browse a share on the server easiliy or is that also slow.
Invariably this is caused by a DNS issue. Try removing these a Vladim says
to see what happens.

"SF" <soc...@online.com.kh> wrote in message
news:us0%23K2%23WDH...@TK2MSFTNGP12.phx.gbl...