[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Remote issues with database

My client had one site with 30 users.  He opened up another office 12 miles away & there is a T1 connection on both ends with a pix doing site-to-site for them.  He took 25 users to work at the new office & every one of the PCs use a propietary hand-written application that they use to track orders/invoices/inventory/etc.  The 2003 Server housing the dbase of that application is located in the new office.  The users at the new office don't see a change in speed but the users in the old office report a startup time of about 5 minutes.  Any ideas on how to get that speed down?

0
mentisgroup
Asked:
mentisgroup
1 Solution
 
KCTSCommented:
What is the DBMS - is it SQL ?
0
 
mentisgroupAuthor Commented:
No.  It is written in Access but can be converted into SQL with some manipulation.
0
 
Mayank SAssociate Director - Product EngineeringCommented:
I think you should look at using a production database like Oracle, SQL Server, MySQL, etc - depending on how much you want to pay.

Access isn't really a DB - its like a glorified address-book, and it won't support too many concurrent connections. Plus the remote connection using ODBC will also be slow.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now