Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Reducing Round Trips - Part 2 Expand / Collapse
Author
Message
Posted Monday, August 19, 2002 2:16 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 10:51 AM
Points: 6,779, Visits: 1,860
I think it varies. Both will work, assigning the recordset to the listbox is definitely easy though may not be powerful/flexible enough. Figure out how you want to handle the binding, then do the caching. Caching is a separate and easily added feature...well, more or less!

Andy
http://www.sqlservercentral.com/columnists/awarren/




Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #26941
Posted Thursday, August 22, 2002 9:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 21, 2009 8:39 AM
Points: 16, Visits: 2
Ah, a blind spot in my knowledge. <G> So how do you assign an ADO.recordset to a listbox?
Is it just listbox.rowsource = adors ?




Post #26942
Posted Thursday, August 22, 2002 1:54 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 10:51 AM
Points: 6,779, Visits: 1,860
Datasource.

Andy
http://www.sqlservercentral.com/columnists/awarren/




Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #26943
Posted Friday, February 6, 2004 7:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 13, 2007 9:22 PM
Points: 15, Visits: 1
Excellent - I esp. like the versioning. I implemented an in-memory cache for an emissions monitoring system [processing 600 calcs/minute], but did not handle the versioning as elegantly as you did here. The calculator runs as service, so little gain in persisting to disk, but that is an excellent idea for some other web site interface [pick lists again!]... May have to go revisit that code.


Post #99064
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse