Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2003

    Red face Unanswered: Sorry, posted in wrong forum


    im accessing a database (MSDE) over the Internet using a VPN and DSL. Everything works fine, except that the transfer speed drops to 1-2kb if a query with "SUM" is used. I had a similiar problem with all my queries before - to get descent transfer rates, the cursortype and locktype had to be deleted from all recordset-statements (Im using ADO recordsets in VB6)

    It should neither be a perfomance problem (locally, everything works fine) nor a problem with the VPN (all other queries get 12-20kb) and the size of the database is rather small - about 6 tables with less then 300 entries... I really cant figure out why only queries with the SUM-operator are affected :-(

    Any help would be great!

    Andreas Koch
    Last edited by ghizmo; 07-09-03 at 09:06.

Posting Permissions

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