Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2007-03-30 : 04:11:56
|
| Hi,We have a document tracking application at my company which is extremely slow to load up and causes delays when staff log into their machines. This is because its launched from the login script. The application has an Access DB as the backend and is getting quite full which is why I think the performance is so poor.My question is, can I upsize the DB to SQL server and link the tables into Access to improve performance?I wasn't sure if this would make that much of a difference.Thanks in advanced! |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-03-30 : 14:12:37
|
| yes you can depends on the version of access but i have converted an access db into a sql server backend running an access front end, and yes it would increase the perform as you will be able to insert indexes etc to tuning and inprove performance--------------------------You only learn by practicing |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-02 : 02:34:25
|
| The likelihood is that you will have to restructure your slow running queries to take best effect of SQL Servers capabilities, but (assuming you have large volumes of data, which is why your application is slow with Access) then your queries are likely to run much fasterIf your slow query is doing something like:SELECT * FROM MyTablethen if anything it will get slower moving it to a Client/Server platform!Kristen |
|
|
|
|
|
|
Upsizing of Access DB