Re: Tweaking database performance

If it's taking long time to connect to the database server, there could
be some problems in the network. If the queries are taking long time to
run, create a trace by using the sql profiler and find out the
reason.(It could be locks, recompile or table scans)

.

Relevant Pages

  • Re: Abstracting a database class
    ... I like this idea and the possibility of running "DB queries" against a ... real DB, the filesystem, or the network. ... Prev by Date: ...
    (comp.lang.php)
  • Re: Local tables or linked local database?
    ... How good of a job does Access do mitigating the amount of ... You have used passthrough queries. ... network load - with a network full of people sending emails, printing, ... My posts come from my experience. ...
    (comp.databases.ms-access)
  • Re: Speed problem
    ... only at one client, their several invoices, etc. ... However, on the network, some things are happening at ... they do bring together a buncha tables via queries). ... mostly on the terminals). ...
    (comp.databases.ms-access)
  • Re: Error when I run Append queries
    ... > running Append Queries I now get an error "Invalid Argument". ... > all of the computers on the network including the server (Frontend in a ... > INSERT INTO PATIENTS ...
    (microsoft.public.access.formscoding)
  • Re: Slow Form Loading Over Network
    ... >So when you have a large table that's stored on a network drive and filter ... >To optimize the queries in the views, you can use the SYSfunction. ... >> The form loads instantly on a standalone machine, ... >> optimized using the tag on DELETED. ...
    (microsoft.public.fox.programmer.exchange)