Re: Migrating away from MS-Access

In my experience, if you convert your Access tables directly over to SQL
Server and do not modify the front end code, you will end up with a
slower application. Regular SQL queries will still need to pull all the
data down from the server before it can process it. All of the existing
SQL queries will need to be converted to stored procedures to see any
type of performance gain.

Also, if the entire Access database resides on the server, this will
cause a performance issue. First try and split front end from backend
(data) and place the front end on the users desktop. I am sure you can
find several possible solutions to update the users front end
automaticaly as modifications are made to it. Later try and pull as many
not core data tables out of the back end and into the front end as they
are found. These tables are usually static tables used for drop downs,
temporary data handling, etc...

Next try and do as much query processing on the front end as possible.
For example if you are running a complex account report lets say, first
just pull down all required fields from all of that account records for
the report. Then do the remaining queries on the front end...



*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: web app for RDA pull
    ... I have a CE device with web server and SQL CE components installed. ... to do it also from a asp file using IIS. ... So what I think is that if the device has all components to do pull from VB ...
    (microsoft.public.sqlserver.ce)
  • Re: Using the ISA reporting from a sql database
    ... I tried to do a report from the reports tab in ISA, ... It comes up empty like it doesnt know where to pull the information from ... since I am logging to another server into sql. ...
    (microsoft.public.isa.configuration)
  • Re: CE Emulator and RDA
    ... can you perhaps run SQL Profiler on the server to see which query ... > I am trying to make my first simple CE project that uses RDA. ... > 5) added a button to the form that executes the example pull code from CE ...
    (microsoft.public.dotnet.framework.compactframework)
  • Empty Error Message when trying to pull Database with RDA
    ... I try to pull some tables from the SQL Server 2000 to the SQL Mobile Server 2005. ... ByVal Login As String, ByVal Password As String, _ ...
    (microsoft.public.windowsce.app.development)
  • ways to connect to MSSQL 2000 sever via vbscript
    ... Please let me know the ways through which we can connect ot MS SQL ... 2000 server in VBscript. ... I mean we can retrive data using sql queries. ...
    (microsoft.public.scripting.vbscript)