SQL Server Temp Tables

  • Thread starter Thread starter V.Balaji
  • Start date Start date
V

V.Balaji

HI,

I have a web applcation which uses a stored procedure as a data source. The
SP selects data from around 4 tables(close 1 Million records) and fills a
temporary table. The logfile of the database grows abnormally due to this,
also the performance is very poor. Any ideas to improve this would be highly
appriciated. Thanks in advance.

Regards,
Balaji
 
V.Balaji said:
HI,

I have a web applcation which uses a stored procedure as a data source.
The SP selects data from around 4 tables(close 1 Million records) and
fills a temporary table. The logfile of the database grows abnormally due
to this, also the performance is very poor. Any ideas to improve this
would be highly appriciated. Thanks in advance.
Click to expand...

Fix your stored procedure.

Think about your desired result:
-How many rows do you want?
-Which rows are they?
-How can you most cheaply just those rows?

David
 
V.Balaji,

Can you give us a little more information of what you are attempting to
accomplish? For instance: Since you mention ASP are you writing a data
paging solution for ASP? Is there something else that you are doing with the
data in this stored proc (e.g. Updates, Deletes, Inserts)? Can the
relational structure of the 4 tables be affecting performance? Which
database log is going up in size? Can you post the code for your stored
procedure?

As you can see without more information I am afraid that we cannot give you
a definite answer on how to help you with your problem just general direction.

Hope this helps
 
Back
Top