• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

TempTable

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
palabros
Asked:
palabros
1 Solution
 
kretzschmarCommented:
? 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now