471,580 Members | 1,614 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

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

Jun 16 '06 #1
4 3281
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)

<ce*******@yahoo.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
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

Jun 17 '06 #2
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:
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)

<ce*******@yahoo.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
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


Jun 19 '06 #3
"ce*******@yahoo.com" <ce*******@yahoo.com> wrote in
news:11**********************@r2g2000cwb.googlegro ups.com:
I did some research and have found some references to the various
option values, based on your post in April this year.


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/
Jun 19 '06 #4
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)


<ce*******@yahoo.com> wrote in message
news:11**********************@r2g2000cwb.googlegro ups.com...
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:
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)

<ce*******@yahoo.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...
> 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
>

Jun 20 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Irmen de Jong | last post: by
2 posts views Thread by Arsen V. | last post: by
reply views Thread by mwhalber | last post: by
2 posts views Thread by =?Utf-8?B?RGFtZW9u?= | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by
1 post views Thread by lumer26 | last post: by
reply views Thread by lumer26 | 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.