Re: Access backend database speed issues with DRW

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin Spencer (kevin_at_takempis.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 07:45:23 -0500

> so how do i deal with it?

Typically, this is done by limiting the number of records returned, and
using paging to view more. The FrontPage database tools will allow you to do
this. 

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"skc" <anonymous@discussions.microsoft.com> wrote in message
news:007c01c3fa61$15ba52d0$a101280a@phx.gbl...
> so how do i deal with it?
>
> >-----Original Message-----
> >> i am only storing the filename of the image.
> >
> >You're doing that part right. As such, I would guess that
> it is the number
> >and total size of the image files being downloaded that
> is causing your
> >speed issue.
> >
> >-- 
> >HTH,
> >Kevin Spencer
> >..Net Developer
> >Microsoft MVP
> >Big things are made up
> >of lots of little things.
> >
> >"skc" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:152b701c3fa20$57827210$a601280a@phx.gbl...
> >> i am only storing the filename of the image.
> >>
> >> the DRW page for the image contains ../images/<%
> >> =FP_FieldVal...%> so that the image uploads from the
> >> images directory based on the image name in my access
> >> table.
> >>
> >> is this correct?
> >>
> >> >-----Original Message-----
> >> >Are you pulling the pictures from the database? That is
> >> very expensive an
> >> >unnecessary. It is much better to put the images into
> the
> >> file system, and
> >> >simply store the image file name in the database.
> >> >
> >> >-- 
> >> >HTH,
> >> >Kevin Spencer
> >> >..Net Developer
> >> >Microsoft MVP
> >> >Big things are made up
> >> >of lots of little things.
> >> >
> >> >"skc" <anonymous@discussions.microsoft.com> wrote in
> >> message
> >> >news:143ba01c3fa12$0cc4df50$a101280a@phx.gbl...
> >> >> Hi,
> >> >>
> >> >> I have made a website using FP2K and Access2K as a
> >> backend
> >> >> database to the site using the FP2K DRW.
> >> >>
> >> >> At the moment, I am trying to resolve a speed
> issue.  Go
> >> >> to www.maslenmotors.com, and click the Showroom tab
> and
> >> >> click View All Cars using Broadband connection.
> >> >>
> >> >> You will find that the page takes absolutely ages to
> >> >> download to a web browser.  I am interrogating the
> >> >> database by using three (or four) parameters such as:
> >> >> Make, Age, Price and I have indexed these fields in
> my
> >> >> Access2K table, by toggling the Indexed (Duplicates
> OK)
> >> >> fields.
> >> >>
> >> >> Please can someone offer me advice on how to speed up
> >> the
> >> >> access.  Is it my indexing, or are the pictures and
> DRW
> >> >> not a good idea?  In which case, how do other people
> do
> >> it?
> >> >>
> >> >> Please help.
> >> >>
> >> >> Skc
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: Database access on a local machine
    ... Kevin Spencer ... >> and database apps; ... >> Microsoft MVP ... >> new stored procedures in the SQL Server database, ...
    (microsoft.public.frontpage.programming)
  • Re: FP2003 with database
    ... "Ray" wrote in message ... >>Microsoft MVP - FP ... I've used the Database wizards, ... >>>> Kevin Spencer ...
    (microsoft.public.frontpage.programming)
  • Re: Upload image into SQL Server database
    ... "Kevin Spencer" wrote in message ... You would have to know> ASP, ASP.Net or some other server-side programming technology to do it. ... You can build a data> entry form that inserts data into a database. ... >>> Microsoft MVP ...
    (microsoft.public.frontpage.programming)
  • Re: IIS does not support ASP on local machine
    ... Kevin Spencer ... >> Microsoft MVP ... >> tab, the Execute Permissions are set to 'Scripts only'. ... >>> Database Results Wizard Error ...
    (microsoft.public.frontpage.programming)
  • Re: Procedural ["bare ASP.NET"] versus OOPy ASP.NET
    ... > If you have nothing constructive to say, please keep your peace. ... > OOP languages and the ability to move code from one language to ... > K> Kevin Spencer ... > K> Microsoft MVP ...
    (microsoft.public.dotnet.framework.aspnet)