Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Server Creep (v2K)

    I created a database on our LAN with the front-end and back-end in one file while I developed it. It functioned fine and the response time was excellent. Upon completion, I copied the database, deleted all the tables from the original and linked the tables from the copy to the interface in the original. These are the normal steps I use to create a front-end/back-end database.
    The problem is the response time. A drop-down that responded instantly now takes 7 seconds to show the values. Everything is ridiculously slow using the front-end/back-end. There are less than 1,000 records and the size of the database is small. As mentioned, it runs great as a single file. Usually the response time isn't hindered when a database is split so this is why I'm puzzled.
    Any help would be appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Server Creep (v2K)

    How does it run if you move both the front and back end to the local machine? How does it run with the front end on a local machine and the back end on the server? Did you remember to turn off subdatasheets and Name AutoCorrect? Those two items sap performance, especially with linked tables.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Server Creep (v2K)

    A local front-end/back-end setup works fine. A LAN b/e - local f/e is still painfully slow.
    Autocorrect is off and the subdatasheet is on. I'll turn the subdatsheet off tomorrow and will test performance. I also picked-up additional advice from posts you, Mark and Wendell made earlier this year to a similar question.
    Thanks!

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Server Creep (v2K)

    You'll need to turn off subdatasheets for *each* table. I found the subdatasheets to be the biggest culprit in very slow loads, but one way to test it is to simply try to open the linked table from the front end database window. If opening the table like that is slow, then subdatasheets may very well be the problem.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Server Creep (v2K)

    Charlotte,
    Thanks so much. I can't believe the subdatasheets had that much of an impact. I removed the subdatasheets and loaded a few tables used for drop-downs on the front-end since they are static. Everything is running fine now.
    Thanks and have a great day!

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Server Creep (v2K)

    Amazing, isn't it? I've never figured out what they were thinking when they designed subdatasheets and then made them always on by default! <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •