|
What database are you using? If MSSQL or Oracle, you could write stored procedures or views to do the statistical calculations server side, and just return the results. This is likely to be much more efficient than pulling all of the data client side and then calculating
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
As all the others have stated, you are using the wrong tool for the job. You are using the CLIENT, used to display stuff, to do the work of a SERVER, used to crunch stuff. Use the database to crunch the data the client needs to display.
Most LOB developers work with volumes like these and never do the crunching on the client. We have a policy that we never send more than 2k records to the client. There are exceptions but the business has to sign in blood to get them accepted.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: We have a policy that we never send more than 2k records to the client.
I like the fact you have a setup a real limit for this. 
Out of curiousity, you do look at the record size too right? eg. I send way more than 2k records to my client website, but they are merely timestamp/value pairs. If I would need to send several megabyte blobs I would limit that severely 
|
|
|
|
|
V. wrote: you do look at the record size too right
No, all our data is text and none will amount to a lot per record so we don't go past the record count. I did catch one guy trying to pass a list of 1k records with attached documents up to 20mb EACH. Nailed that rather quickly. You want an attachment you get it one at a time, here have a list of file names!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I suggest you to download the data first, instead of keeping such a huge data in in-memory.
You can download the data to the client and store it in MSAccess or .TXT. Later use your code to do the calculation on the data.
|
|
|
|
|
Hi,
does anyone has a good tutorial on pagination , I searched the internet no tutorial walking.
Thank you
|
|
|
|
|
|
its not working I already tried
|
|
|
|
|
It would have helped if you had stated that in the original question. What does "not work" mean? Does it not compile, does it throw an exception?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
there errors when connecting and following precedents and next BUTTONS do not work properly
|
|
|
|
|
We know that you can see your code, but you have to understand that we can't. We cannot see your Visual Studio output window or your debugger. Can you see why we cannot help you here? We can see no code and no exceptions.
|
|
|
|
|
..and the other articles produce the same error? Or a different one?
You can try and solve the error, ask the original author for help (there's a forum at the bottom of the article) or find some other example.
I'd still recommend dropping paging completely.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I have no other solution I have too much data I need to do pagination
|
|
|
|
|
That does not mean that other solutions do not exist; paging is usually not done in a WinForm, even if there's a lot of data. We don't have a "pagelimit" as a book has, the complete concept of having a "page" should remain on the web, not in Forms.
Having a page is half an anti-pattern - most people will only use the first page at all times.
Large datasets can be loaded quickly by virtualizing the grid, and there's filtering to limit the dataset fetched.
Still, if you want pagination, you'd have to find a working component, or adapt one of the existing ones to your needs.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Virtualization is a very good solution for me but there is no tutorial to explain and I am beginner so it's hard for me 
|
|
|
|
|
|
Golden Upvote for Patience Above and Beyond ... awarded 
« I am putting myself to the fullest possible use which is all, I think, that any conscious entity can ever hope to do » HAL (Heuristically programmed ALgorithmic computer) in "2001, A Space Odyssey"
|
|
|
|
|
this totoriel is not well explained it is very difficult
|
|
|
|
|
|
Yup, you're right; it is complexer than simply binding. It takes more time to write, and it takes some extra time to change the structure to something that loads on demand - but then the grid will load and display fast, even scrolling the grid with the mouse will be rather quick.
I've never tried the code from the HowTo that you linked, but I did complete the Walkthrough. To me, the walkthrough looks like it is simpeler. The idea is easier to follow if you only implement a readonly-datagrid, meaning you'd only implement the <a href="http://msdn.microsoft.com/nl-nl/library/windows/apps/system.windows.forms.datagridview.cellvaluen">CellValueNeeded</a>[<a href="http://msdn.microsoft.com/nl-nl/library/windows/apps/system.windows.forms.datagridview.cellvaluen" target="_blank" title="New Window">^</a>]-event. Not the push, no delete, only the stuff to display the data.
I always make mistakes when implementing those together, so I always start with a readonly-grid. One part to load the data into a List (of object-arrays), executed on a separate thread, and the CellValueNeeded event that gets the data from that list and displays is. If you have 10 items in the list, you set the RowCount value of the grid to ten, and the grid will ask a value for each visible item.
Another reason I like the approach is because it allows me to display a ProgressBar that shows how much is loaded - no white forms for five seconds while databinding, but a nice progressbar with a Cancel button.
There's other alternatives though; one I read here that sounds as a logical and quick solution is to fetch up to a maximum. I think the most common solution is to add another filter, to force the user to think about specifying more precisely which data he/she needs.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Normally we can configure SSL in internet explorer setting and it works fine for Thick application.
But if we run the application using Visual Studio then it is not using the SSL settings of IE.
|
|
|
|
|
Do you mean when running you site from Visual Studio in debug mode?
I can't see a reason why not, but maybe you are running on different IIS while debugging?
Try to add as much relevant info as you have...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
תפסיק לספר לה' כמה הצרות שלך גדולות, תספר לצרות שלך כמה ה' גדול!
|
|
|
|
|
|
The link you show us here is ****. You can use a simple function like
public static void ProtectConfiguration()
{
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
config.ConnectionStrings.SectionInformation.ProtectSection(null);
config.Save(ConfigurationSaveMode.Full, true);
}
|
|
|
|
|
if your way encryption, decryption can still be, but the example above you do not decipher if you do not have private const string SharedSecret = "?????";
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
