Solved

Slow speed in SQL Pervasive calls on certain router conditions

Posted on 2011-03-05
12
491 Views
Last Modified: 2012-06-22
I use Pervasive SQL (ODBC has Pervasive Engine loaded)
On certain locations (meaning different locations in the country,)  when connected on the router (by hub) it takes some 20 seconds before SQL  responds, if I disconnect network cable its fast!
0
Comment
Question by:BIAPRO
  • 8
  • 4
12 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 35043137
Can we assume that the database is on the local system, with data on the local hard disk?
Otherwise, this makes little sense, as without the NIC cable, the call will fail.

Can you set yp Wireshark and get a network trace of the calls going out over the network?  I expect that you'll see a call going out that does not get a reply -- perhaps a DNS lookup, based on the time -- and if you know what is failing, you can figure out how to fix it.
0
 

Author Comment

by:BIAPRO
ID: 35043156
Yes the database is local,  as I stated when not on the network conneted ist fast, i just have to disconnect every time my internet
will download wireshark and test it
0
 

Author Comment

by:BIAPRO
ID: 35043201
when connected to the net and using a test call in the odbc to the database whiresharks generated the attached log.
my ip in this log is 192.168.1.36 for this workstation
the log itself does not (with my level of knowledge)  not tell me what makes the delay on the odbc / sql call

shark1.jpg
0
 

Author Comment

by:BIAPRO
ID: 35043207
0
 

Author Comment

by:BIAPRO
ID: 35043209
0
 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
ID: 35056896
The problem seems to be the MDNS queries, which are issued, but no reply ever comes back.  Here's a starting point:
    http://laurachappell.blogspot.com/2009/06/iphone-youre-sexy-but-you-talk-too-much.html
But you can query mDNS in your favorite web search tool for more information.

These multi-cast DNS queries are being issued when you are connected to the network, but the system is waiting for a response.  You will probably find the system runs faster after you take some steps to disable it.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:BIAPRO
ID: 35060383
hi Bill, it was searching and searching , I did discover 2 networkprinters wich were on usb anyway, so turned off their IP's, but more important to this problem I discovered this way that the pervasive engine was not only looking for Ms-TCP/IP mode but multi mode.
After turning all mode's off, and only left Ms-TCP/IP mode on did solve the problem
Thanks
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 35060707
Can you post the exact steps you used to disable the other modes?  That will make this article a perfect reference for someone in the future.
0
 

Author Comment

by:BIAPRO
ID: 35060902
this tab in pervasive settings

modes.jpg
0
 
LVL 28

Expert Comment

by:Bill Bach
ID: 35060928
Wow!  I forgot all about those options from Pervasive.SQL 2000i!  In all of the newer engines, it is merely a checkbox for TCP.  I would guess, then, that you wouldn't have an issue with any of the newer engines.
0
 

Author Comment

by:BIAPRO
ID: 35061102
I understand Bill,  but since I have a few (and coming) pervasive dos users (netware) in the process off stepping from total dos  tpo total windows (perv. v10 and up)  I must use 2000i since I was never able to get the Btrieve dos client working in Perv. v10+
and some programs are still not converted from dos to VB6 and can't miss them
0
 

Author Comment

by:BIAPRO
ID: 35061114
this way I  can run on XP both VB6 and compiled dos on the same server
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now