[AccessD] Delete query... fast ... deleting from datasheet view... slow

  Yes, the temp DB's are in the directory specified by TEMP and/or TMP and
are prefixed with ~JET

  Not having TEMP or TMP set correctly can yield a "Disk or network I/O
error" message.

  The UseTransactions property also comes into play as to how JET handles
the delete as well as whether you have the DB opened exclusive or not.

  Also of note, if a remote ODBC DB is involved, you need to be careful with
the delete queries.  If you use anything in the query that is Access/JET
specific (ie. a VBA expression) or a join to a local table, then JET ends up
issuing one ODBC call for each row that it wants to delete instead of
sending one SQL delete statement to the backend.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, July 04, 2011 07:24 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Delete query... fast ... deleting from datasheet
view... slow

Hi William and Stuart

Yes in memory, if possible. If not, in some temp db in the temp folder of
the current user of Windows.

/gustav


>>> stuart at lexacorp.com.pg 04-07-2011 12:45 >>>
I suspect it is only stored in memory.

On 4 Jul 2011 at 5:51, William Benson wrote:

> 
> Where does Access store the temp table Gustav? In other words if you
> open a monstrously large table select all records and do several faux
> deletes one after another which you confirm but cancel at the
> "Continue without Undo?" Prompt....does the database bloat I wonder! I
> will check this when I get back to computer!_



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com