| PaulJS 2005-03-30, 9:41 am |
| Hi,
I have a requirement to place a scanned JPEG file of a single 8.5x11 sheet
of paper into a table called "tblChangeOrder". The JPEG is a scan of the
customer-signed-and-approved Change Order document. Although I have no
problem getting the picture file into the image data type field in the SQL
Server table, I'm experiencing very slow performance in the front end, which
is MS Access XP (not an Access Project, just a plain Access MDB front end).
For instance, I run a query returning just two records containing the field
in question. I right-click the "image" column in the first record and open
the picture in MS Photo Editor to view it. Then I close it (no
modifications), and try to click on the next record. It takes almost a half
to a full minute to move to the next record. The picture file is relatively
small and I'm looking for recommendations on using the image data type and
hopefully to try and speed things up. Here's some specifics:
Back end is SQL Server 2000 w/ latest service pack as of this date.
Front end is MS Access XP w/ latest service pack as of this date.
The JPEG file I'm using for test is about 250 KB (not MB).
The image data is for read-only in MS Access.
The test system has only 2 computers on the network: a server and a
workstation. Therefore, network traffic is very minimal.
Thanks for your help!
--
PaulJS
|