|
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 9:24:10 AM
Posts: 6,216, Visits: 6,078 |
| | Jeff, I have reset your ES license again so that you can take another stab at it. Let me know if this doesn't get you going. |
| |
| | | StrataFrame Team Member
Group: StrataFrame Users
Last Login: 02/25/2010 6:11:20 PM
Posts: 298, Visits: 633 |
| Sorry about that! I had the form pulled up but didn't press save  .You should be good to re-register now. |
| |
| | | StrataFrame User
 
Group: StrataFrame Users
Last Login: Today @ 11:20:22 AM
Posts: 160, Visits: 340 |
| Good news. ES is finally up and running on my test server. I hope that once I get my testing done that my production server will be a lot easier to setup. One question I do have. The database has a table with over 100,000 records that the client needs to see all at one time, but I got a timeout error when loading these records into a grid using a BO mapped to SQL Server View. Where do I increase the timeout to adjust for loading these records using ES? Thanks, Jeff |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 9:24:10 AM
Posts: 6,216, Visits: 6,078 |
| This would be on the SqlCommand, not the server timeout. So you would create the SqlCommand and set the timeout to a really high number or 0 for infinite.
However, let me suggest possible another route. Why would you need all 100,000 records at once? If you are trying to perform an incremental search, then you can create a threaded loader so that every time you type in a new character, it gets added to the queue, gets passed over to the server to s SPROC which executes the query, and sends back a TOP result set. Generally I limit my TOP results to 100 (or possible 1000) when I do something like this. This way you get a really fast, real-time search. To date, I have never needed or seen a reason for having 100,000 records client side. |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 11:20:22 AM
Posts: 160, Visits: 340 |
| | Hi Trent, I agree with you. I am going to have to provide some filtering capabilities for the client that will meet his requirements as you suggested. I have no experience with threading. So would you provide me some code examples about how I can accomplish this incremental search. Thanks, Jeff |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 9:24:10 AM
Posts: 6,216, Visits: 6,078 |
| | To save you some time, I have created a sample showing how to do this. I couldn't remember what language you used, so it is in C#. It is easy to convert, though, and I will try to post a VB.NET sample later. But either way, this should get you going and you can see what I was getting at. Here is that sample: http://forum.strataframe.net/FindPost25669.aspx |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 11:20:22 AM
Posts: 160, Visits: 340 |
| | Hi Trent, Thank you so much for the example. I'm using VB.NET, but after looking at the example, I believe I can convert the C# code. Jeff |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 9:24:10 AM
Posts: 6,216, Visits: 6,078 |
| | Glad it helped. |
| |
|
|