I missed that there was any size limit on the number of records that a BO could handle (independent of hardware/network resources). I'll be interested to see if there is a limit.



Of course, network and hardware would likely be a limiting factor even if the BO can handle an unlimited number of records. 125 million records would require some serious memory and/or network connectivity (if you try to bring them all into the BO on a client machine....125 million records on an appropriately sized "modern" db server is very doable/done all the time). And then there is the issue of what in the world world would a user do with 125 million records available on their machine? If they browse a records every second, it would take something like 4 years to go through them (assuming no sleeping, eating, biology breaks at all).



If all 125 million records were all needed to perform some business logic, then I'd try to use SQL first. Or I'd try a server solution that sat very near the db (which might use a SF BO...if there aren't any limits). I know the SF guys use CLR sprocs to do heavy lifting like this, with great results (SQL 2005+).



Just some thoughts. I was intrigued by the post and thought I'd share them.

Yeah, everything that Greg said is very true.  I think that it pretty much re-emphasizes what I was saying but from just another perspective

I would agree that I would never intend to have anywhere near a million records let alone 125 million in a BO. I was simply interested to find out if 1 million was the physical limit as indicated in the help file. My reasoning is if SF can handle a BO with a million records then it will handle one with 10,000+.

As I mentioned in an earlier post, I have had problems with another system that simply can't handle a large no of rows. True, even 10,000 records can be considered large but it should be possible to handle it.

Thanks guys.

I can see why I couldn't find the Infragistics wrapper - it is looking for 7.3 and I have 8.1 installed.

Nevermind, at least I know where to look.

You can get that version here: http://forum.strataframe.net/Topic15184-22-1.aspx

Yeah, you should be good here.  We don't attempt to update all records, only records that have changed.  So this part won't be an issue.

The link appears to be for DevExpress. I tried it anyway just in case but the Infragistics wrapper is still looking for 7.3

Thanks

Hi Aaron.

Try to follow these steps, and open the "MicroFour StrataFrame Infragistics Wrapper"  solution instead of the "MicroFour StrataFrame Inherited UI":

http://forum.strataframe.net/FindPost14742.aspx

LOL...I thought about this on the drive home   When you purchase the framework, Ivan's solution will work as you have the source code and can hange the references.  I have not yet taken the time to download 8.1 of Infragistics...so I will see if I can get that done sometime this week.  Sorry.

Don't worry as we may have ordered by then. I can still test with the UltraGrid directly and the BusinessBindingSource. See, I am already posting like I know what I am talking about

Thanks.