Project question.

Project question.
Hi, I'm developing a DB that is as follow:
This DB is for control the Credit Cards information. Then it has a lot of
movement.
1-I have a client.
2-This client has an account
3-This account can has a many cards ( for exemple: credit card
international, credit card gold.) each one whit your rules (like: limit,
date of pay.)
4- And I have a table that receives all transactions, for example: (very
simplified)
Client '1010 1010 1010 1010' buy product that have cost of $100,00 ,date
05/05/05
Client '1010 1010 1010 1010' buy product that have cost of $50,00 , date
05/20/05
.
Client '2020 2020 2020 2020' buy product that have cost of $80,00 ,date
05/04/05
Client '2020 2020 2020 2020' buy product that have cost of $50,00 , date
05/18/05
.
I need made calculations to generate a bill for each client each month.
My question is: When I have 1 million of client (consequently 5 million of
transaction in this table to month) and I need make calculations, this table
will work. (It won't be locked)
How I should do this.
Anyone have experience with a lot of data. How work with a lot of data that
need be calculate.
Any think is important to me.
Thank you very much.Hello,
You may want to consider use Horizontal partitioning
http://msdn.microsoft.com/library/d...-us/optimsql/od
p_tun_1_11ev.asp
http://www.sqlteam.com/Item.ASP?ItemID=684
Also, general query optimation is necesary for each specific query:
HOW TO: Troubleshoot Slow-Running Queries on SQL Server 7.0 or Later
http://support.microsoft.com/?id=243589
http://www.sql-server-performance.com/mr_indexing.asp
INF: Index Tuning Wizard Best Practices
http://support.microsoft.com/?id=311826
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "ReTF" <re.tf@.newsgroup.nospam>
| Subject: Project question.
| Date: Wed, 3 Aug 2005 09:32:57 -0300
| Lines: 74
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <OjmzhbCmFHA.3256@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: 200-211-161-64-amr.cpe.vivax.com.br 200.211.161.64
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.programming:109244
| X-Tomcat-NG: microsoft.public.sqlserver.programming
|
| Project question.
|
|
|
| Hi, I'm developing a DB that is as follow:
|
|
|
| This DB is for control the Credit Cards information. Then it has a lot of
| movement.
|
|
|
| 1-I have a client.
|
| 2-This client has an account
|
| 3-This account can has a many cards ( for exemple: credit card
| international, credit card gold.) each one whit your rules (like: limit,
| date of pay.)
|
| 4- And I have a table that receives all transactions, for example: (very
| simplified)
|
|
|
| Client '1010 1010 1010 1010' buy product that have cost of $100,00 ,date
| 05/05/05
|
| Client '1010 1010 1010 1010' buy product that have cost of $50,00 , date
| 05/20/05
|
| .
|
| Client '2020 2020 2020 2020' buy product that have cost of $80,00 ,date
| 05/04/05
|
| Client '2020 2020 2020 2020' buy product that have cost of $50,00 , date
| 05/18/05
|
| .
|
|
|
| I need made calculations to generate a bill for each client each month.
|
|
|
| My question is: When I have 1 million of client (consequently 5 million
of
| transaction in this table to month) and I need make calculations, this
table
| will work. (It won't be locked)
|
|
|
| How I should do this.
|
|
|
| Anyone have experience with a lot of data. How work with a lot of data
that
| need be calculate.
|
|
|
|
|
| Any think is important to me.
|
|
|
| Thank you very much.
|
|
|
|
|