High Volume Data over LAN/WAN/VPN etc...

In an effort to optimize and speed up applications.....
(I have a minimum 15,000 record (20+ fields) database, multi-user(<5)
over WAN)


In theory...

Is there a technique out there where high volume data is "uploaded" on
program start, from the back end file (split database) on a remote
machine (LAN/WAN/VPN etc...) to the front end local machine and update
the back end with changes when the front end closes?
(I'm aware that synchronizing changes with other users may be tricky.)

or

Some form of "Paging" the data in a datasheet view in browsable chunks,
where as the user browses, the front end requests more data from the
back end (in small, yet speedy chuncks). (Users normally see all
records, (that is, the datasheet "contains" all records) and "drill
down" from there.)

Any ideas or links are appreciated.

Christopher

re: High Volume Data over LAN/WAN/VPN etc...

Yes, you can increase the size of the Jet cache, and
increase the time out interval so that stuff is not
invalidated out of the cache. Have a look at the dbengine
option settings.

(david)

<cefrancke@yahoo.com> wrote in message
news:1150465446.204320.174110@i40g2000cwc.googlegr oups.com...[color=blue]
> In an effort to optimize and speed up applications.....
> (I have a minimum 15,000 record (20+ fields) database, multi-user(<5)
> over WAN)
>
>
> In theory...
>
> Is there a technique out there where high volume data is "uploaded" on
> program start, from the back end file (split database) on a remote
> machine (LAN/WAN/VPN etc...) to the front end local machine and update
> the back end with changes when the front end closes?
> (I'm aware that synchronizing changes with other users may be tricky.)
>
> or
>
> Some form of "Paging" the data in a datasheet view in browsable chunks,
> where as the user browses, the front end requests more data from the
> back end (in small, yet speedy chuncks). (Users normally see all
> records, (that is, the datasheet "contains" all records) and "drill
> down" from there.)
>
> Any ideas or links are appreciated.
>
> Christopher
>[/color]

re: High Volume Data over LAN/WAN/VPN etc...

Thanks David,

I did some research and have found some references to the various
option values, based on your post in April this year.

I have a split database,


Do I set the option on the back end or front end?
Is the option permanent once it is set?
Should it be set at the start of the application? (All the tables are
being loaded here for my app)
Do I need to reset the setting back when the app is closed?
Do I need to set the options on every machine I deploy the app on?

Thanks for your consideration,

Christopher


david epsom dot com dot au wrote:[color=blue]
> Yes, you can increase the size of the Jet cache, and
> increase the time out interval so that stuff is not
> invalidated out of the cache. Have a look at the dbengine
> option settings.
>
> (david)
>
> <cefrancke@yahoo.com> wrote in message
> news:1150465446.204320.174110@i40g2000cwc.googlegr oups.com...[color=green]
> > In an effort to optimize and speed up applications.....
> > (I have a minimum 15,000 record (20+ fields) database, multi-user(<5)
> > over WAN)
> >
> >
> > In theory...
> >
> > Is there a technique out there where high volume data is "uploaded" on
> > program start, from the back end file (split database) on a remote
> > machine (LAN/WAN/VPN etc...) to the front end local machine and update
> > the back end with changes when the front end closes?
> > (I'm aware that synchronizing changes with other users may be tricky.)
> >
> > or
> >
> > Some form of "Paging" the data in a datasheet view in browsable chunks,
> > where as the user browses, the front end requests more data from the
> > back end (in small, yet speedy chuncks). (Users normally see all
> > records, (that is, the datasheet "contains" all records) and "drill
> > down" from there.)
> >
> > Any ideas or links are appreciated.
> >
> > Christopher
> >[/color][/color]

re: High Volume Data over LAN/WAN/VPN etc...

"cefrancke@yahoo.com" <cefrancke@yahoo.com> wrote in
news:1150752166.191245.262410@r2g2000cwb.googlegro ups.com:
[color=blue]
> I did some research and have found some references to the various
> option values, based on your post in April this year.[/color]

Why not just set up a terminal server on the WAN and let users run
the apps that way? It's much easier, requires no tweaking and won't
cause latency problems of any significance in comparison to
attempting to use Jet across a LAN. And the licensing costs are
quite minimal.

Save yourself the headaches and do it the easy way.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

re: High Volume Data over LAN/WAN/VPN etc...

You set the option on the copy of dbEngine that you are using.

The options are not permanent. If you want permanent values,
set the equivalent values in the registry.

It doesn't matter when you set the options: set before you
need them. Change them to whatever you want.

You need to set the options each time you use the dbengine
(unless you set the registry values).

Have you seen the demo version of Access on the Microsoft site?
Note that when MS wants to demonstrate Access for many users on
the internet, they use a Terminal Services session.

(david)




<cefrancke@yahoo.com> wrote in message
news:1150752166.191245.262410@r2g2000cwb.googlegro ups.com...[color=blue]
> Thanks David,
>
> I did some research and have found some references to the various
> option values, based on your post in April this year.
>
> I have a split database,
>
>
> Do I set the option on the back end or front end?
> Is the option permanent once it is set?
> Should it be set at the start of the application? (All the tables are
> being loaded here for my app)
> Do I need to reset the setting back when the app is closed?
> Do I need to set the options on every machine I deploy the app on?
>
> Thanks for your consideration,
>
> Christopher
>
>
> david epsom dot com dot au wrote:[color=green]
>> Yes, you can increase the size of the Jet cache, and
>> increase the time out interval so that stuff is not
>> invalidated out of the cache. Have a look at the dbengine
>> option settings.
>>
>> (david)
>>
>> <cefrancke@yahoo.com> wrote in message
>> news:1150465446.204320.174110@i40g2000cwc.googlegr oups.com...[color=darkred]
>> > In an effort to optimize and speed up applications.....
>> > (I have a minimum 15,000 record (20+ fields) database, multi-user(<5)
>> > over WAN)
>> >
>> >
>> > In theory...
>> >
>> > Is there a technique out there where high volume data is "uploaded" on
>> > program start, from the back end file (split database) on a remote
>> > machine (LAN/WAN/VPN etc...) to the front end local machine and update
>> > the back end with changes when the front end closes?
>> > (I'm aware that synchronizing changes with other users may be tricky.)
>> >
>> > or
>> >
>> > Some form of "Paging" the data in a datasheet view in browsable chunks,
>> > where as the user browses, the front end requests more data from the
>> > back end (in small, yet speedy chuncks). (Users normally see all
>> > records, (that is, the datasheet "contains" all records) and "drill
>> > down" from there.)
>> >
>> > Any ideas or links are appreciated.
>> >
>> > Christopher
>> >[/color][/color]
>[/color]