Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

network or local machine

Discussion in 'Information Technology' started by neeraj, Nov 18, 2005.

  1. neeraj

    neeraj
    Expand Collapse
    Guest

    The users of my database with backend on network and frontend on their
    computer are complaining about the slow speed of running reports. There are
    only
    a few users and the users dont make any changes to tables. If I were to
    install the entire unsplit database on each user's computer, they would be
    able to able to run reports much faster. I have to make fortnighly additions
    to these tables so I will have to update the database on their computers
    every time but I have to update backend tables anyways with the existing
    setup. I am hoping to get feedback and ideas on this.
     
  2. Loading...

    Similar Threads Forum Date
    Sone Bhambhani Joins Sikh Philosophy Network! New SPN'ers Thursday at 9:11 AM
    Gigi S Joins Sikh Philosophy Network! New SPN'ers Wednesday at 10:44 AM
    Khalis International Joins Sikh Philosophy Network! New SPN'ers Nov 23, 2016
    Gurdeep Kaur Joins Sikh Philosophy Network! New SPN'ers Nov 22, 2016
    Arshdeepsingh Joins Sikh Philosophy Network! New SPN'ers Nov 22, 2016

  3. G. Vaught

    G. Vaught
    Expand Collapse
    Guest

    Don't do that, don't unsplit the database on each users machine. You will
    have updating nightmares.

    The mostly likely problem is the server you are using and the connectivity
    between them and the machine.

    The other possibility is you need to compact/repair the database when nobody
    is connected to the database. First, make sure that everyone has the
    frontend closed on their own machine. If you issue a compact/repair be sure
    you open the database in exclusive mode. After you do the backend, then do
    each user's machine.

    The last possibility is that the reports need redesigning.

    "neeraj" <neeraj@discussions.microsoft.com> wrote in message
    news:9FCBBE5B-A8AA-4C6F-9376-C93D61724FDB@microsoft.com...
    > The users of my database with backend on network and frontend on their
    > computer are complaining about the slow speed of running reports. There
    > are
    > only
    > a few users and the users dont make any changes to tables. If I were to
    > install the entire unsplit database on each user's computer, they would be
    > able to able to run reports much faster. I have to make fortnighly
    > additions
    > to these tables so I will have to update the database on their computers
    > every time but I have to update backend tables anyways with the existing
    > setup. I am hoping to get feedback and ideas on this.
    >
     
  4. G. Vaught

    G. Vaught
    Expand Collapse
    Guest

    I read your post again and the last sentence has me perplexed. If you link
    the tables into the frontend, their is no updating needed by anybody other
    than the data entry people. You may have your frontend/backend connected
    incorrectly.


    "neeraj" <neeraj@discussions.microsoft.com> wrote in message
    news:9FCBBE5B-A8AA-4C6F-9376-C93D61724FDB@microsoft.com...
    > The users of my database with backend on network and frontend on their
    > computer are complaining about the slow speed of running reports. There
    > are
    > only
    > a few users and the users dont make any changes to tables. If I were to
    > install the entire unsplit database on each user's computer, they would be
    > able to able to run reports much faster. I have to make fortnighly
    > additions
    > to these tables so I will have to update the database on their computers
    > every time but I have to update backend tables anyways with the existing
    > setup. I am hoping to get feedback and ideas on this.
    >
     
  5. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    You don't mention the number of users, and how large these tables are.

    What I would do before you consider trying to send all the data as a single
    mdb file to each computer is simply check some things to restore
    performance.

    The #1 trick to restore performance is to try a persistent connection. (that
    means in your startup code in the front end, you open a table to the back
    end ..and KEEP it open). Give this concept a try, as this usually restores
    performance back to un-split levels.

    It does depend on what kind of network you are also talking about? Is the
    office network of high quality and speed?

    Also, check out the following performance eFAQ, as it tells you about the
    persistent connection (that I seen speed things up by MORE THEN a factor of
    100 times!!). Check each of the suggestions, and by the time you are
    finished, you may have adequate performance that you can continue to share
    the data as is..


    http://www.granite.ab.ca/access/performancefaq.htm

    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  6. neeraj

    neeraj
    Expand Collapse
    Guest

    There is no data entry in my database by users. Users are using database only
    to run reports(queries). These queries are based on sales data table which is
    a part of the backend lying on the server. I have to append records to this
    table every 2 weeks or so. The FE with all the queries/reports etc. is on the
    users' computers. This is the setup that I have now. I am debating whether I
    really need to split the database as I am doing now or if I can load the
    entire unsplit database on each user's machine . I dont see any reason for
    splitting the database because there is no data entry by users; please let me
    know if I am wrong.

    "G. Vaught" wrote:

    > I read your post again and the last sentence has me perplexed. If you link
    > the tables into the frontend, their is no updating needed by anybody other
    > than the data entry people. You may have your frontend/backend connected
    > incorrectly.
    >
    >
    > "neeraj" <neeraj@discussions.microsoft.com> wrote in message
    > news:9FCBBE5B-A8AA-4C6F-9376-C93D61724FDB@microsoft.com...
    > > The users of my database with backend on network and frontend on their
    > > computer are complaining about the slow speed of running reports. There
    > > are
    > > only
    > > a few users and the users dont make any changes to tables. If I were to
    > > install the entire unsplit database on each user's computer, they would be
    > > able to able to run reports much faster. I have to make fortnighly
    > > additions
    > > to these tables so I will have to update the database on their computers
    > > every time but I have to update backend tables anyways with the existing
    > > setup. I am hoping to get feedback and ideas on this.
    > >

    >
    >
    >
     

Share This Page