?
Solved

MY SYBASE ASA DATABASE CONNECTS SLOW

Posted on 2005-03-07
6
Medium Priority
?
538 Views
Last Modified: 2010-05-18
I HAVE A VPN CONNECTION BETWEEN TWO OFFICES I CONNECT FINE AND I CAN ACCESS THE DATABSE FINE. BUT IT CONNECTS VERY SLOW. WHEN I OPEN PERFECT CARE AND LOGON IT LITERALLY TAKES 5 MINUTES TO COMPLETE THE LOGON AND THE DAT MOVES SLOW. I HAVE IDSL 384 UP 384 DOWN ON BOTH SIDES WHAT CAN I DO TO MAKETHIS MORE EFFCENTLY.
0
Comment
Question by:ullmanneric
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 

Author Comment

by:ullmanneric
ID: 13483364
I AM USING RRAS AS MY VPN SETUP
0
 
LVL 8

Expert Comment

by:RevelationCS
ID: 13488272
get a faster connection. Remember, your connection is shared and when VPNing it still has to pass the data over that shared connection and the internet before it reaches back to you....
0
 

Author Comment

by:ullmanneric
ID: 13491993
BUT LET ME ASK YOU THIS ALOS WHY IS MY LAN SIDE SLOW NOW AFTER ADDING THE VPN SYSTEM WE USED RRAS
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 8

Expert Comment

by:RevelationCS
ID: 13492571
the last question is a completely different question as to why your lan is slow that is most likely not related to the VPN connection... also, I think by the 5 other posts that you have made regarding this intertwined issue that most of us already know that you are using VPN and RRAS so you dont need to keep repeating it in capital letters... The issue to your connection above is you have a slow connection that is being shared by multiple machines which will slow your download of the dat files and logon time down depending on the number of users using the DSL connection ON BOTH sides of the VPN... depending on the number of users, you might want to look at getting business class DSL which should give you 1.5MB speeds and would greatly improve your transfer time between locations via the VPN...
0
 

Author Comment

by:ullmanneric
ID: 13492668
my vpn is only used at night time when we are not even at the office, nobody connected through our vpn then so if you read what i am saying you would understand that my lan side is slow as well, that 100 base network it was not slow until the vpn was added that internally not using the dsl connection and by the way our dsl connection is soho 1.5 so it not a slow dsl connection
0
 
LVL 8

Accepted Solution

by:
RevelationCS earned 2000 total points
ID: 13492979
according to above (your first statement), you said you had 384x384... another thing to remember is your distance from the CO (central office - aka where all the teleco hardware is located for your phone provider) depends on how good of that actual advertised speed you get... very few people will actually get the full speeds...  also, if one end is 384/384 and the other end is 1.5, the fasted you will download is still what you clock on the 384/384 side of things...  try running some tests from the following site to determine the status of both connections and their true download speeds: http://www.dslreports.com/tools and post the results back here....

have you checked your network for any viruses/trojans/worms that might be hogging the system?  how large are the dat files? check to make sure autoupdates and other automated downloads by software/AV/firewalls are not updating at this same time... network card settings (both sides of the VPN)... there is a whole slew of items to look at to determine the cause of the slowdown... all of these topics, however, are best suited for the networking channel than the database channel...  
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Whoever said that “a picture is worth one thousand words” observed a fact that can dramatically affect your marketing success. Most people tend to learn visually, so many publishers commonly acknowledge the effectiveness of visual learning by using…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

719 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