Wednesday, March 28, 2012

Images from SQL Server

I'm populating an Access continuous form with lots of icons from a SQL
Server backend. If I remove the field holding the icons from the
stored procedure, the form loads 5X faster. Is there any sort of trick
to improve the performance of this sort of scheme?
lqHi

The loading of the form is not just the returning of the dataset, but also
the conversion of the data into the icon. You may want to test the speed of
the queries through query analyser. You may also want to validate if the
size and datatype of the column to see if you can cut the size down, another
alternative is to load the icons from disk and only have references to them
in the database.

HTH

John

"Lauren Quantrell" <laurenquantrell@.hotmail.com> wrote in message
news:47e5bd72.0311080647.2655d2f3@.posting.google.c om...
> I'm populating an Access continuous form with lots of icons from a SQL
> Server backend. If I remove the field holding the icons from the
> stored procedure, the form loads 5X faster. Is there any sort of trick
> to improve the performance of this sort of scheme?
> lq

No comments:

Post a Comment