471,853 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

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?
lq
Jul 20 '05 #1
1 1361
Hi

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" <la*************@hotmail.com> wrote in message
news:47**************************@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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Mark Allison | last post: by
3 posts views Thread by Tim T | last post: by
3 posts views Thread by Simon | last post: by
10 posts views Thread by Neo Geshel | last post: by
12 posts views Thread by Jon B | last post: by
9 posts views Thread by Wayne Smith | last post: by
12 posts views Thread by John Kotuby | last post: by
76 posts views Thread by rcoco | last post: by
8 posts views Thread by Frank Millman | last post: by
7 posts views Thread by Keith Hughitt | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.