473,241 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 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 3342
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Irmen de Jong | last post by:
Hi, Things like Twisted, medusa, etc.... that claim to be able to support hundreds of concurrent connections because of the async I/O framework they're based on.... can someone give a few...
3
by: etienno | last post by:
Hi, what would be the best way to transfert high volume data (100 tables, 500Meg each) between DB2/AS400 to Sybase? Thanks Etienne. Montreal
2
by: Arsen V. | last post by:
Hello, Did anyone have some experience with the following: 1) Need to track high volume of impressions - 20,000,000+ per day 2) Backend is SQL Server 2000 3) Webfarm of IIS with ASP.NET 4)...
5
by: Ron Mexico | last post by:
I have written a graphing engine (very similar to what BigCharts.com offers). Basically, it's an ASPX page that accepts parameters and calls back-end business objects (dlls) to create a graph. ...
0
by: mwhalber | last post by:
Hi, I am developing an application which highlights changes in streaming data (i.e. market changes.) I have developed this initially using the BackColor and ForeColor settings on the relevant...
3
by: peterc | last post by:
I have an existing database with approx 500,000 rows and accessed by a few hundred users per day creating approx 1,000 new records per day plus typical reporting - relatively low volume stuff for...
1
by: Tommaso Caldarola | last post by:
I need to transfer big files (up to 10 Gb), now I'm using IIS via Remoting with chunk of bytes (up to 500Kb). In the following article: Middle-Tier Hosting: Enterprise Services, IIS, DCOM, Web...
2
by: =?Utf-8?B?RGFtZW9u?= | last post by:
Hi - I am attempting to write lines to a file at high volume, multiple threads. Here is my scenario: (initial "WriteToFile" object created via a parent multithreaded process, which receives...
1
by: Ted | last post by:
I have cross posted this to comp.lang.c++ and to sci.math.num- analysis in the belief that the topic is of interest to some in both groups. I am building my toolkit, in support of my efforts in...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.