adp question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan Crawford - 19 May 2005 08:21 GMT

Hi

I am used to using local temp tables in and mdb file to speed up
some functions.

How would this work with an adp file where the temp table is created
on the server? What would happen if two people used the same table?

thanks

jonathan

Signature

===============
Jonathan Crawford
01273 440018
07799 068570
fax 01273 380221
jc@jcrawford.co.uk
===============

Reply to this Message

Alex White MCDBA MCSE - 19 May 2005 10:44 GMT

Yes you use server side temp tables look in the SQL books online for help,
also you can create the #temp tables so that individual users cannot see
other peoples #temp tables.

but to get the best from a temp table on the server you should populate them
from stored procedures on the server as everything is them running locally,
the speed improvement is substantial.

Signature

Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

> Hi
>
[quoted text clipped - 7 lines]
>
> jonathan

Reply to this Message