Click here to Skip to main content
16,007,610 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
Questionhow to: Pass status information through tiers? Pin
theitmueller10-Apr-08 5:01
theitmueller10-Apr-08 5:01 
AnswerRe: how to: Pass status information through tiers? Pin
Luc Pattyn10-Apr-08 6:42
sitebuilderLuc Pattyn10-Apr-08 6:42 
AnswerRe: how to: Pass status information through tiers? Pin
Mark Churchill10-Apr-08 20:10
Mark Churchill10-Apr-08 20:10 
AnswerRe: how to: Pass status information through tiers? Pin
Member 9611-Apr-08 8:43
Member 9611-Apr-08 8:43 
AnswerRe: how to: Pass status information through tiers? Pin
Member 247162112-Apr-08 1:00
Member 247162112-Apr-08 1:00 
AnswerRe: how to: Pass status information through tiers? Pin
stavinski12-Apr-08 11:55
stavinski12-Apr-08 11:55 
AnswerRe: how to: Pass status information through tiers? Pin
Oakman17-Apr-08 14:10
Oakman17-Apr-08 14:10 
QuestionBest Design approach - thoughts; ideas; comments Pin
JoeContreras10-Apr-08 3:16
JoeContreras10-Apr-08 3:16 
Hi All,

I'm been task to migrate a classic ASP website to ASP.NET - I intend to migrate to ASP.NET 2.0 (bare min.) using C#.

There is a processing engine which is causing much problems and dims the lights out when this is run.

What the processing engine does:

From a conceptual level it's a very straightforward process. What this processing page does is reconciles data against two data sources and if there is match on the first level of Ids then it goes to the next level of Ids and checks if there are mismatches for that level. If there are then it records those mismatch records. If there are matches at this level then it goes to the next level and check for mismatches between records at this level. Keep in mind that all these ids need to be linked together back to the master Id. My Id structure is like this:
Master ID - check datasource 1 against datasource 2
Match goto to second level
Child1 ID- check ds1 against ds2
Match goto to third level
GrandChildID - check ds1 against ds2
Match goto to fourth level
GreatGrandChildID - check ds1 against ds2

How this is handle in classicASP:

Currently this contains a huge initial openrecordset which is never closed. It does a 4000 code line do loop and creates embedded SQL with "Select * From" queries and creates recordsets and opens the recordsets but never closes those recordsets. Mind you when a user has to process say 50k to 100k records this thing absoultely bombs out. And in the creation of SQL on the fly it creates an IN function with over 1,000 ids in that IN clause which maximizes the the total number of Ids you can have in IN functions.

Design Questions:

1. Where to begin with this?
2. Should I go database processing or business rule engine?
3. How to improve workflow and performance for records reaching close to 1 million?
4. Should I create an interface for the user to add more rules?

Any starting points or case studies to at least get me to design mode. I would be most grateful.

Thanks,
GeneralRe: Best Design approach - thoughts; ideas; comments Pin
Pete O'Hanlon10-Apr-08 3:27
mvePete O'Hanlon10-Apr-08 3:27 
GeneralRe: Best Design approach - thoughts; ideas; comments Pin
Member 9611-Apr-08 8:52
Member 9611-Apr-08 8:52 
QuestionDesign Methods ?? Pin
Julia4u9-Apr-08 11:52
Julia4u9-Apr-08 11:52 
AnswerRe: Design Methods ?? Pin
Pete O'Hanlon9-Apr-08 11:58
mvePete O'Hanlon9-Apr-08 11:58 
General[Message Deleted] Pin
Julia4u9-Apr-08 12:05
Julia4u9-Apr-08 12:05 
GeneralRe: Design Methods ?? Pin
Julia4u9-Apr-08 12:06
Julia4u9-Apr-08 12:06 
AnswerRe: Design Methods ?? Pin
Ravi Bhavnani9-Apr-08 12:03
professionalRavi Bhavnani9-Apr-08 12:03 
Answeris this forum dead? Pin
Luc Pattyn9-Apr-08 12:08
sitebuilderLuc Pattyn9-Apr-08 12:08 
AnswerRe: Design Methods ?? Pin
Julia4u9-Apr-08 16:02
Julia4u9-Apr-08 16:02 
GeneralRe: Design Methods ?? Pin
Shog99-Apr-08 16:31
sitebuilderShog99-Apr-08 16:31 
GeneralRe: Design Methods ?? Pin
Julia4u9-Apr-08 16:49
Julia4u9-Apr-08 16:49 
GeneralRe: Design Methods ?? Pin
Pete O'Hanlon9-Apr-08 21:41
mvePete O'Hanlon9-Apr-08 21:41 
GeneralRe: Design Methods ?? Pin
Leslie Sanford10-Apr-08 22:44
Leslie Sanford10-Apr-08 22:44 
AnswerRe: Design Methods ?? Pin
Pete O'Hanlon9-Apr-08 21:52
mvePete O'Hanlon9-Apr-08 21:52 
GeneralRe: Design Methods ?? Pin
Leslie Sanford10-Apr-08 22:50
Leslie Sanford10-Apr-08 22:50 
GeneralRe: Design Methods ?? Pin
Pete O'Hanlon11-Apr-08 2:50
mvePete O'Hanlon11-Apr-08 2:50 
GeneralRe: Design Methods ?? Pin
darkelv11-Apr-08 1:26
darkelv11-Apr-08 1:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.