Results 1 to 4 of 4

Thread: ipaq very slow

  1. #1
    Join Date
    Nov 2004
    Posts
    4

    Unanswered: ipaq very slow

    i've a system installed over ipaq and delivered to reps,
    each rep make pull for his data from his ipaq to a server (sql2000 sp3) and sqlce server.
    the pull time takes big time around 30 or 40 minutes.
    anyone can help to minimize this time.

    thanks in advance
    maha

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Make sure that NONE of the processing (or as little as possible) is performed on the IPAQ, which obviously has less power than a server and may require large datasets to be transferred to it over (relatively) slow network connections in order to run you querys.
    Ideally, your synchronization should have the IPAQs call stored procs on the server to get their data.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    How does the pull take place and whats the process?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Are they talking about Pull subscription?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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