Consulting

Results 1 to 4 of 4

Thread: Why is the exact same query impossible to execute on the network?

  1. #1

    Why is the exact same query impossible to execute on the network?

    I'm trying to execute a query on an access file from inside an excel spreadsheet it's taking a ton of time to execute. Is there something that can be done or am I going to be forced to use sql server? Takes seconds to execute on the local drive.

  2. #2
    VBAX Expert
    Joined
    Oct 2012
    Posts
    726
    Location
    Make sure your database tables are properly normalised and your fields are indexed and have datatypes only as big as needed.

  3. #3
    Yes, I normalized all the fields, important fields are indexed and appropriate data types have been assigned. Impossible may have been an exageration, but a query that takes 5 seconds on my laptop (database is on the same drive), takes 5 minutes across the network. I was wondering why that was and whether or not switching to SQL server would improve that speed and by how much (thinking that query would be executed on server and only resulting records would be sent accross network).

  4. #4
    VBAX Expert
    Joined
    Oct 2012
    Posts
    726
    Location
    Sounds like your network is just very slow, in which case a database server probably would be quicker but it's not possible to say by how much.

Posting Permissions

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