Split Data from 1 table to 2

Question

Split Data from 1 table to 2

Rad-1011401

SSC Enthusiast

Points: 152
More actions
July 29, 2009 at 6:12 am

#212602

Hi, hoping for some help please.
We have data from different clients in 1 table. For a particular client, the loading of their pages are getting very slow so I need to remove their data prior to 01/01/09 and place in a new table. The Start Date filter on the front end will be defaulted to 01/01/09
but this data does need to be available incase they set the date filter prior ro 01/01/09.
What's the best way to do all of this process? Bear in mind, I only need to get the data prior to 01/01/09 if the date filter is set and to ignore it otherwise.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Allister Reid SSCrazy Points: 2666 More actions · Answer 1

Have you got any indexes on table in question? Adding appropriate indexes would probably be the best solution, you would get better performance without having to change code in web app to handle two different tables.

Without more details, I can't help any more than this.

Rad-1011401 SSC Enthusiast Points: 152 More actions · Answer 2

yes, there are indexes in the table.

For other clients with less data, the pages load quickly.

The problem lies with the loading and with the editing/updating for this particular client.

Allister Reid SSCrazy Points: 2666 More actions · Answer 3

Are the indexes appropriate to the query(s) your are have problem(s) with? I am unclear on your problem and therefore how to help without further information.

The following link provides guidance on posting for help on performance related problems: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Allister Reid SSCrazy Points: 2666 More actions · Answer 4

Allister Reid

SSCrazy

Points: 2666

July 29, 2009 at 6:35 am

#1031601

How many records are we talking about here?

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 5

Rad (7/29/2009)
yes, there are indexes in the table.
For other clients with less data, the pages load quickly.

Chances are indexing strategy may require some re-work 😉

What do you see in offending query's explain plan?... FTS perhaps?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.