David S
|
| Posted: 08/03/2002, 12:32 AM |
|
I've just started a site using an Access database. I am finding it takes
about 20 seconds to load a record page. The most complex thing this page has
to do is make a listbox with 550 values via a join to another table.
When other people have to use this the delay will really cheese them off, so
I was wondering if this is typical of Access or if there is something else I
should look to alter to improve the load time.
Thanks
Dave
|
|
|
 |
Shawn Mason
|
| Posted: 08/03/2002, 9:37 AM |
|
Access is not a really good choice for web development. It was never
designed for many,many connections. A listbox with 550 elements is quite
large and might be seemingly unwieldy for you users. I would say that
unless you are logging somewhere, that your bottleneck is Access and the
size of the listbox in tandem. Remember, the page must first gather the
listbox elements and then send them to the page. Look at the source from
your browser and see what size it is. It may be a very large page it is
transmitting. If the 550 elements is a must, then you might look at doing a
lookup page where a link would open another window with a grid and the user
would select one of these..the selected value would then be transferred back
to the original page. There is an article on www.gotocode.com that is
similar. It addresses adding a new element to a listbox w/o losing the
forms values while doing so.
--
Kindest Regards,
Shawn Mason,CCD,MCP
I.S. Software Design Associates
"David S" <gatton@clara.co.uk> wrote in message
news:aig0u2$925$1@news.codecharge.com...
> I've just started a site using an Access database. I am finding it takes
> about 20 seconds to load a record page. The most complex thing this page
has
> to do is make a listbox with 550 values via a join to another table.
>
> When other people have to use this the delay will really cheese them off,
so
> I was wondering if this is typical of Access or if there is something else
I
> should look to alter to improve the load time.
>
> Thanks
>
> Dave
>
>
|
|
|
|
David S
|
| Posted: 08/03/2002, 2:26 PM |
|
Thanks for your advice Shawn & I'll try to follow your suggestion.
(Unfortunately I've been ordered to use Access by my employer - I put the
site together in mysql at first, on my home PC, and it was much quicker).
Dave S
"Shawn Mason" <shawn@issda.com> wrote in message
news:aih0ru$70r$1@news.codecharge.com...
> Access is not a really good choice for web development. It was never
> designed for many,many connections. A listbox with 550 elements is quite
> large and might be seemingly unwieldy for you users. I would say that
> unless you are logging somewhere, that your bottleneck is Access and the
> size of the listbox in tandem. Remember, the page must first gather the
> listbox elements and then send them to the page. Look at the source from
> your browser and see what size it is. It may be a very large page it is
> transmitting. If the 550 elements is a must, then you might look at doing
a
> lookup page where a link would open another window with a grid and the
user
> would select one of these..the selected value would then be transferred
back
> to the original page. There is an article on www.gotocode.com that is
> similar. It addresses adding a new element to a listbox w/o losing the
> forms values while doing so.
>
> --
> Kindest Regards,
>
> Shawn Mason,CCD,MCP
> I.S. Software Design Associates
>
> "David S" <gatton@clara.co.uk> wrote in message
>news:aig0u2$925$1@news.codecharge.com...
> > I've just started a site using an Access database. I am finding it takes
> > about 20 seconds to load a record page. The most complex thing this page
> has
> > to do is make a listbox with 550 values via a join to another table.
> >
> > When other people have to use this the delay will really cheese them
off,
> so
> > I was wondering if this is typical of Access or if there is something
else
> I
> > should look to alter to improve the load time.
> >
> > Thanks
> >
> > Dave
> >
> >
>
>
|
|
|
|
RonB
|
| Posted: 08/04/2002, 1:59 PM |
|
My company was using a lot of acces databases. I've convinced them to move
over to MySQL on all but a few. When more then 10 people are using the
database it's being moved to mysql and I write an interface with CCS via the
intranet. Seeing the speed an scalability of MySQL compared to Acces, and
not to mention the difference in price  , it didn't take them long to just
love MySQL.
RonB
"David S" <gatton@clara.co.uk> schreef in bericht
news:aihhp5$42m$1@news.codecharge.com...
> Thanks for your advice Shawn & I'll try to follow your suggestion.
> (Unfortunately I've been ordered to use Access by my employer - I put the
> site together in mysql at first, on my home PC, and it was much quicker).
>
> Dave S
>
>
> "Shawn Mason" <shawn@issda.com> wrote in message
>news:aih0ru$70r$1@news.codecharge.com...
> > Access is not a really good choice for web development. It was never
> > designed for many,many connections. A listbox with 550 elements is
quite
> > large and might be seemingly unwieldy for you users. I would say that
> > unless you are logging somewhere, that your bottleneck is Access and the
> > size of the listbox in tandem. Remember, the page must first gather the
> > listbox elements and then send them to the page. Look at the source
from
> > your browser and see what size it is. It may be a very large page it is
> > transmitting. If the 550 elements is a must, then you might look at
doing
> a
> > lookup page where a link would open another window with a grid and the
> user
> > would select one of these..the selected value would then be transferred
> back
> > to the original page. There is an article on www.gotocode.com that is
> > similar. It addresses adding a new element to a listbox w/o losing the
> > forms values while doing so.
> >
> > --
> > Kindest Regards,
> >
> > Shawn Mason,CCD,MCP
> > I.S. Software Design Associates
> >
> > "David S" <gatton@clara.co.uk> wrote in message
> >news:aig0u2$925$1@news.codecharge.com...
> > > I've just started a site using an Access database. I am finding it
takes
> > > about 20 seconds to load a record page. The most complex thing this
page
> > has
> > > to do is make a listbox with 550 values via a join to another table.
> > >
> > > When other people have to use this the delay will really cheese them
> off,
> > so
> > > I was wondering if this is typical of Access or if there is something
> else
> > I
> > > should look to alter to improve the load time.
> > >
> > > Thanks
> > >
> > > Dave
> > >
> > >
> >
> >
>
>
|
|
|
|
|
