Database Speed

[WaaX]

Hi,

Im looking for way to speed up my data access, i was wondering if anyone have made some test, calculating the time it took to populate 1000 items in a list box, just to know what is the fastest way, benchmark!

If you got some link or tip, post them here please

[Lee M.]

The first thing I have to ask is what DB are you using?
MS Access is notoriously slow, because the entire access form has to be loaded into memory for the app to access it. SQL Server is better, Unix as well. However I know that these are not available to most users, so you do what you have to. I wrote an app. with MS Access that loaded 5000 individual strings of data (6 bytes each). The app ran ok at best on my Pentium III (800 MHZ), but pooped out on the Pentium II (233 mhz). Oh don't get me wrong, it loaded! But I could have went to lunch and back quicker!
Lee

[WaaX]

hehe, mine wont be that big
its an Access one. But without considering the database, im most concern on how you access your data, with a data environment, by binding the recordset to the listbox or by making a do while... or a For .. Next, ADO Data Control, there is a lot of way to do it.

[Lethal]

Me personally, i do not like using data controls in general. I tend to use ado objects instead. Just my .02 cents..

[Lee M.]

I preffer to pass a refrence to the ado. ado is really the best thing going at this point.

[F14tomcat]

I use unbound controls. Using a command object I pass a variable to a stored procedure and populate a listbox. I return x number of items based on the variable. I tried using a null and it took 11 seconds to return all 31352 items from one column in the database. When I request all columns 31352*8(columns) it took 19 seconds. Not bad, but still not fast enough.

[lengwai]

i've learned from my fren that there are certain controls which could do the job better than ADO does, in terms of performance.

For instance using a List Viewer. Data could be loaded directly into the Viewer instead of recordset.
I think it does make sense but i do not know how true is that.

I understand that MS Access is really slow, but is there another way in which it could at least improve the performance?

Currently i am using ADO as my data control.Well still at development stage. But in my working environment, you can really get out and get a quick lunch.

One control my organization is using did really improved the performance of the its latest release by using an Extended List View control to take charge of the data access.