|
Hi,
I have an application in which I display records in a grid. I populate the grid using a recordset that contains the results of a query of the database.
The problem is that if I have a large database (about 80,000 records and above..) then it takes a few minutes to load the grid with all of the records.
I need to make this faster... Any ideas?
|
|
|
|
|
|
Yeah - what I thought to do is show the first 400 records (for example), while searching for the other records.
I thought to load the data page by page, and display 400 records in each page.
So, it would work this way: display 400 records, then display another 400 (800 total), then another 400 (1200 total) and so on until I reach 78000 records.
But how can I do this with the recordset object?
Do I have to fill the recordset first with 400 records, then with 800 records, then with 1200 records, and eventually with 78000?
|
|
|
|
|
SWDevil wrote: So, it would work this way: display 400 records, then display another 400 (800 total), then another 400 (1200 total) and so on until I reach 78000 records.
only load the ones you need to display. if they scroll, load enough new data to complete the grid, and discard the rest.
ideally, if your grid control allows, you can put it in charge of loading the data for the rows it has to display when it needs them. don't make it load data it doesn't need - just let it ask for rows X through Y when it needs to display them, and don't worry about any other rows.
Cleek | Image Toolkits | Thumbnail maker
|
|
|
|
|
ok - I understand your idea, but I don't understand how to actually implement it...
First of all - how can I know if I can put my grid control in charge of loading the data it needs?
Second - Let's say my grid control can't be put in charge of loading the correct data, how do I implement your idea?
Do I have to perform a new query each time?
For example: "SELECT * FROM TABLE1 WHERE field BETWEEN x and y" and then display the recordset that contains the result set?
Also - won't this solution take a lot of time also? isn't the solution of loading page by page better?
|
|
|
|
|
SWDevil wrote: how can I know if I can put my grid control in charge of loading the data it needs?
i don't know what you're using for your grid, but some of the standard Windows controls allow this. for example, the CListCtrl can act as a "Virtual list control", which means it will send you a message when it needs data for an item. the MSDN has info on this.
SWDevil wrote: Do I have to perform a new query each time?
ideally, you would cache some data.
SWDevil wrote: Also - won't this solution take a lot of time also? isn't the solution of loading page by page better?
you're only ever loading, at most, the number of lines you can display at once, so the control will load faster and won't be required to maintain a large amount of memory to hold all the items.
Cleek | Image Toolkits | Thumbnail maker
|
|
|
|
|
Hi All,
Can anyone tell me how to increase the max number of right click menus displayed on any particular icon on the desktop in Win XP?
Thanks and Regards,
Anil
|
|
|
|
|
Soory not quite sure about that.
check Micheal Dunn's "The Complete Idiot's Guide to Writing Shell Extensions" series. It might be useful.
SaRath.
"Don't Do Different things... Do Things Differently..."
|
|
|
|
|
how can i use WinINet to download a file through many connection and not only one like all the download manager
thx
bye
|
|
|
|
|
Hi.
I´ve made a screen capture code using the PrintWindow function, been my input parameter the window handle I want to capture. This window has some buttons, labels, ... that as you may know act as child windows for the first.
It all works fine, mostly, but every 500 or 700 grabs I get one or two of them where child elements appear as black rectangles.
I've read [1] about something like this when child windows style is CS_CLASSDC or CS_PARENTDC. Obviously, I do not create the windows I capture, so I can't change that style.
So, I don't know how to face the problem. Maybe a PrintWindow alternative, but I need independence of the z-order (deep) of the window, getting a clear capture even if the window is not foreground.
Thanks in advance.
[1]http://www.codeguru.com/cpp/g-m/gdi/capturingimages/comments.php/c11231/?thread=9097
|
|
|
|
|
In the WebBrowser application how to get the size of the window which includes the Html document in it , and the scrollbars also.
Regards
Shikha
NetStudio,Pune
|
|
|
|
|
I guess your problem is scroll do you use CHtmlView?
whitesky
|
|
|
|
|
Thanks for your reply .
Yes, i have used the CHtmlView class in my application and i want the size of the html page document i can get size of the window with scrollbar by using getscrollinfo function but it is again not giving the size of the window having the html document.
Regards
Shikha
Netstudio,Pune
|
|
|
|
|
Did you see GetHeight and GetWidth in this class
whitesky
|
|
|
|
|
Yes i can get the GetHeight,GetWidth function but again from that just i can get the height of the window without scrollbars which is not the whole size of the html document.
Regards
Shikha
Pune
|
|
|
|
|
Shikha Jain wrote: In the WebBrowser application how to get the size of the window which includes the Html document in it , and the scrollbars also.
is api GetWindowRect of any use?
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief and You
|
|
|
|
|
Thanks for your reply,
But GetClientRect() only gives the client area size of the window i want the whole page size of the html document i.e with the scrollbars also.
Regards
Shikha
Netstudio,Pune
|
|
|
|
|
Actualy in the previous mail it is by mistake i have written GetClientRect .
yes GetWindowRect you have suggested ,
i have tried that but it again gives the size of the window excluding the scrollbars i.e not the whole html document size .
Regards
Shikha
Pune
|
|
|
|
|
Supposing you actually need the full size of the HTML document, including the parts out of client area, a possible solution can look like this:
CComPtr< IHTMLDocument3 > doc = (IHTMLDocument3*)GetHtmlDocument();
IHTMLElement * doc_element;
doc->get_documentElement(&doc_element);
CComQIPtr<IHTMLElement2> element = doc_element;
long width;
long height;
element->get_scrollWidth(&width);
element->get_scrollHeight(&height);
Please note that the sizes are available only for fully loaded HTML documents, when GetReadyState() returns an appropriate value.
Hope this is what you need in your HTML-capturing application.
|
|
|
|
|
Hi,
I have a program coded in vc++6 and ms access as the database.The data connection is done using DAO.
Suppose I run this program on a computer that does not have microsoft office installed, will it still work? i.e. will it still be able to connect to the database?
If not, will installing the microsoft jet engine be sufficient?
Thanks,
Tara
Fortitudine Vinsinues!
-- modified at 4:22 Sunday 4th June, 2006
|
|
|
|
|
You dont need to install MS Office, but you have to install MDAC. Jet engine will come as part of MDAC.
cheers..Milton KB
|
|
|
|
|
Milton KB wrote: install MDAC
Please can you tell me what is MDAC. Is it something which is freely available?
Tara
Fortitudine Vinsinues!
|
|
|
|
|
|
Thanks a lot, Sir.
Fortitudine Vinsinues!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
