Solved

TempTable

Posted on 2002-06-27
1
260 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi Form ownership 4 160
Breakpoint doesn't stop in my variable 3 48
Delphi: sending SMS on android platform 1 104
Delphi Firemonkey : user drawing in window 3 56
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

739 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