Solved

TempTable

Posted on 2002-06-27
1
258 Views
Last Modified: 2010-04-04
i am using temp table
i am finding that the entire process of storing data  is slowing down to a huge extent when i run the procedure for second time.
wheather is there anything that i have to care of while coding using temptable. i am creating the table on form create to a temp directory.and closing when proc ends.
i destroy the table at the end of the main form close.

plz comment
pala
0
Comment
Question by:palabros
1 Comment
 
LVL 27

Accepted Solution

by:
kretzschmar earned 100 total points
ID: 7113038
? what database

if you use the table only for this instance of your app,
then set the exclusive-property to true before opening the table. this will disable the recordlocking-mechanism and the open is faster.

meikl ;-)
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question