Home » Developer & Programmer » Designer » Table Design for Billing purpose
Table Design for Billing purpose [message #252612] Thu, 19 July 2007 07:02 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
hi all

I want to develop a software for Billing purpose

A company want to record a all sales in computer and at the month end want to print our billing for all clients I have design this in foxpro and in Foxpro we did that when new month will start then new table generate like Crd_0707 (Credit month year).

now I want to develop in oracle how I should start this project I mean who can I design tables.

thanks

Re: Table Design for Billing purpose [message #252628 is a reply to message #252612] Thu, 19 July 2007 08:26 Go to previous message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd avoid creating a new table for every month. Perhaps you would want to read more about partitioned tables.

Whatever it is, Oracle allows you to have HUGE tables and write queries against them. With proper indexing and performance tuning, you'll be able to print reports for all clients in no time.
Previous Topic: Design decision - Table partitioning for archiving?
Next Topic: What is user's pre qualification to connect to Oracle Designer
Goto Forum:
  


Current Time: Sun Apr 20 13:35:45 CDT 2014

Total time taken to generate the page: 0.09626 seconds