sujitkar
04-04-2009, 01:16 PM
Hi,
I have just started to develop one website for my company. The database is in Sql Server 2005. There I have two tables-
Manual_Data Table
1. Mat_ID (Containing the ID of the Materials)
2. Date (Containing the Date of Stock Taken, Generally once in a week)
3. Quantity (Quantity of the material)
This table gives us the physical_qty_sold per week, if we deduct the previous week data from the latest week data. Actually it gives the sold qty within any period of time.
Auto_Data Table
1. Mat_ID
2. Date
3. Qty (Quantity Sold)
4. Qty_sold_till_date
Whenever we sell something, the record is being updated in the Auto_Data Table. Thus we get the total qty_sold_till_date. And also, we can calculate the qty_sold within a period of time.
Now I have been asked to put the Material Audit option in my website. It should generate the difference between two sold quantities, i.e. the physical sold qty and the sold_qty as per auto_data table.
To solve this, I had to take 4 Recordsets in my application - one for Quantity (from manual_Data) on the start date, one for Quantity (from manual_Data) on the End date, one for Quantity_sold_till_date (from auto_Data) on the start date, one for Quantity_sold_till_date (from auto_Data) on the End date.
But when I am trying to open my website in the intranet only (including localhost), it is taking around 4-5 mins to load. Looking forward for your help.
I have just started to develop one website for my company. The database is in Sql Server 2005. There I have two tables-
Manual_Data Table
1. Mat_ID (Containing the ID of the Materials)
2. Date (Containing the Date of Stock Taken, Generally once in a week)
3. Quantity (Quantity of the material)
This table gives us the physical_qty_sold per week, if we deduct the previous week data from the latest week data. Actually it gives the sold qty within any period of time.
Auto_Data Table
1. Mat_ID
2. Date
3. Qty (Quantity Sold)
4. Qty_sold_till_date
Whenever we sell something, the record is being updated in the Auto_Data Table. Thus we get the total qty_sold_till_date. And also, we can calculate the qty_sold within a period of time.
Now I have been asked to put the Material Audit option in my website. It should generate the difference between two sold quantities, i.e. the physical sold qty and the sold_qty as per auto_data table.
To solve this, I had to take 4 Recordsets in my application - one for Quantity (from manual_Data) on the start date, one for Quantity (from manual_Data) on the End date, one for Quantity_sold_till_date (from auto_Data) on the start date, one for Quantity_sold_till_date (from auto_Data) on the End date.
But when I am trying to open my website in the intranet only (including localhost), it is taking around 4-5 mins to load. Looking forward for your help.