473,714 Members | 2,406 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Why does splitting a mdb make it slower?

I have an A97 application that is NOT split on a network. It is used by
15+ folks continually. It is quick and fast.

I split it several years ago and had to merge it together again after
the folks rebelled at the slow speed resulting from the split.

I have to bite the bullet and split it now. Of course, it is much
slower. In one form that opens as a continous form, the data looks like
it is being repainted as it displays...you can see each row being
created quickly. When not split, the entire page is presented in one blink.

I created a table on the backend called KeepOpen. I created a form
called KeepOpen that opens when the app does. This form links to the
linked table. That didn't make much difference. I created an AutoExec
macro that runs a function that opens the the table KeepOpen. Not much
difference.

My forms now take about 5 seconds more to open. I would think that if I
had a frontend on the hard drive and the backend on the network things
would be faster than having an MDB containing a front/backend on the
network.

The network OS my app is Novell. Is it possible that Novell is a
superior operating system to Microsoft and can fetch files and data and
send everything thru the network faster than Microsoft can fetch stuff
on a hard drive?

Is there anything you are aware of that I can do to improve the speed
after splitting the database? Also, I will be porting this A2003. Does
A2003 have better split database management compared to A97?
Jul 18 '07 #1
3 2013
salad <oi*@vinegar.co mwrote:
>I have an A97 application that is NOT split on a network. It is used by
15+ folks continually. It is quick and fast.

I split it several years ago and had to merge it together again after
the folks rebelled at the slow speed resulting from the split.
Yes, that was my experience as well.
>I have to bite the bullet and split it now. Of course, it is much
slower. In one form that opens as a continous form, the data looks like
it is being repainted as it displays...you can see each row being
created quickly. When not split, the entire page is presented in one blink.

I created a table on the backend called KeepOpen. I created a form
called KeepOpen that opens when the app does. This form links to the
linked table. That didn't make much difference. I created an AutoExec
macro that runs a function that opens the the table KeepOpen. Not much
difference.
Interesting. That should've made a substantial difference.
>My forms now take about 5 seconds more to open. I would think that if I
had a frontend on the hard drive and the backend on the network things
would be faster than having an MDB containing a front/backend on the
network.
No, the time spent downloading the queries, forms and reports to the memory of the
workstation from the server doesn't appear to be significant. A client did that with
a Citrix setup and it worked quite well.
>The network OS my app is Novell. Is it possible that Novell is a
superior operating system to Microsoft and can fetch files and data and
send everything thru the network faster than Microsoft can fetch stuff
on a hard drive?
No. A network cable is always a lot slower than a local hard drive. (Of course
someone is going to jump in and mention how slow a 20 year old 10 Mb (not Gb) hard
drive is but you get the idea.)

Also it's my understanding that MS did a great deal of work in Win 2003 Server to get
it as fast as Novell as that was one area in which they were getting beat up on.
>Is there anything you are aware of that I can do to improve the speed
after splitting the database?
See the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Obviously sub datasheet Name property and Track name AutoCorrect won't be a
difference in A97 but will affect you later.

I'm wondering how many folders down on the server is the MDB? Can you try moving it
to one folder below the root. I don't know if Novell would do a better job here than
Microsoft.

Are you reasonably up to date with the Novell clients?
>Also, I will be porting this A2003. Does
A2003 have better split database management compared to A97?
No. There are a few more things you have to concern yourself in A2000 and newer.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jul 18 '07 #2
Tony Toews [MVP] wrote:
salad <oi*@vinegar.co mwrote:
>>I have an A97 application that is NOT split on a network. It is used by
15+ folks continually. It is quick and fast.

I split it several years ago and had to merge it together again after
the folks rebelled at the slow speed resulting from the split.

Yes, that was my experience as well.
Hi Tony. I'm betting you were able to fix it.
>>I have to bite the bullet and split it now. Of course, it is much
slower. In one form that opens as a continous form, the data looks like
it is being repainted as it displays...you can see each row being
created quickly. When not split, the entire page is presented in one blink.

I created a table on the backend called KeepOpen. I created a form
called KeepOpen that opens when the app does. This form links to the
linked table. That didn't make much difference. I created an AutoExec
macro that runs a function that opens the the table KeepOpen. Not much
difference.

Interesting. That should've made a substantial difference.
That's what I thought. From A97 help it states "You can greatly enhance
performance when opening the main database and opening tables and forms,
by forcing the linked database to remain open."
>>My forms now take about 5 seconds more to open. I would think that if I
had a frontend on the hard drive and the backend on the network things
would be faster than having an MDB containing a front/backend on the
network.

No, the time spent downloading the queries, forms and reports to the memory of the
workstation from the server doesn't appear to be significant. A client did that with
a Citrix setup and it worked quite well.
That's interesting. I would have thought that would have added
significant overhead.
>>The network OS my app is Novell. Is it possible that Novell is a
superior operating system to Microsoft and can fetch files and data and
send everything thru the network faster than Microsoft can fetch stuff
on a hard drive?

No. A network cable is always a lot slower than a local hard drive. (Of course
someone is going to jump in and mention how slow a 20 year old 10 Mb (not Gb) hard
drive is but you get the idea.)
Yes. I do. It was an attempt at humor.
>
Also it's my understanding that MS did a great deal of work in Win 2003 Server to get
it as fast as Novell as that was one area in which they were getting beat up on.
>>Is there anything you are aware of that I can do to improve the speed
after splitting the database?

See the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Obviously sub datasheet Name property and Track name AutoCorrect won't be a
difference in A97 but will affect you later.

I'm wondering how many folders down on the server is the MDB? Can you try moving it
to one folder below the root. I don't know if Novell would do a better job here than
Microsoft.
My app is on J:. I am one level down from J:. Ex: J:\Test\MyApp.M DB.

The folder name is 8 characters in length.

My App name is 10 characters in length. My BE is 12 characters in
length...I added BE to the app name for the backend.

Hmmmm...I'll have to check the naming scheme. That would be funny if
the fix to my problem is changing my 12 char backend name to a shorter name.
Are you reasonably up to date with the Novell clients?
My client uses an ex-Novell systems programmer to keep up to date as far
as Groupwise. My client is pretty fanatical about keeping up to date on
Novell...but I will ask him.
>>Also, I will be porting this A2003. Does
A2003 have better split database management compared to A97?

No. There are a few more things you have to concern yourself in A2000 and newer.
Could you provide some further info regarding the above statement? Or
links?
>
Tony
I'll keep you posted on this. Thanks much
Jul 18 '07 #3
salad <oi*@vinegar.co mwrote:
>>>I split it several years ago and had to merge it together again after
the folks rebelled at the slow speed resulting from the split.

Yes, that was my experience as well.

Hi Tony. I'm betting you were able to fix it.
Mostly. Not entirely though. Split was still sluggish compared to unsplit.
>No, the time spent downloading the queries, forms and reports to the memory of the
workstation from the server doesn't appear to be significant. A client did that with
a Citrix setup and it worked quite well.

That's interesting. I would have thought that would have added
significant overhead.
Likewise. But when you take a look at how much memory Access consumes in Task Mgr
once you've opened an MDB well who knows what's all going on there.

>>>The network OS my app is Novell. Is it possible that Novell is a
superior operating system to Microsoft and can fetch files and data and
send everything thru the network faster than Microsoft can fetch stuff
on a hard drive?

No. A network cable is always a lot slower than a local hard drive. (Of course
someone is going to jump in and mention how slow a 20 year old 10 Mb (not Gb) hard
drive is but you get the idea.)

Yes. I do. It was an attempt at humor.
Oops, sorry.
>See the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
>>>Also, I will be porting this A2003. Does
A2003 have better split database management compared to A97?

No. There are a few more things you have to concern yourself in A2000 and newer.

Could you provide some further info regarding the above statement? Or
links?
Specifically the name autocorrect and and the subdatasheets setttings as mentioned at
the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Jul 18 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
14050
by: jsaul | last post by:
Hello all, I have to split a dict into two dicts. Depending on their values, the items shall remain in the original dict or be moved to another one and at the same time be removed from the original dict. OK, this is how I do it right now: dict1 = { "a":1, "b":3, "c":5, "d":4, "e":2 } dict2 = {}
7
3204
by: Jeremy Sanders | last post by:
I have a large string containing lines of text separated by '\n'. I'm currently using text.splitlines(True) to break the text into lines, and I'm iterating over the resulting list. This is very slow (when using 400000 lines!). Other than dumping the string to a file, and reading it back using the file iterator, is there a way to quickly iterate over the lines? I tried using newpos=text.find('\n', pos), and returning the chopped text...
7
1149
by: RickMuller | last post by:
I'm trying to split a string into pieces on whitespace, but I want to save the whitespace characters rather than discarding them. For example, I want to split the string '1 2' into . I was certain that there was a way to do this using the standard string functions, but I just spent some time poring over the documentation without finding anything. There's a chance I was instead thinking of something in the re module, but I also...
3
4140
by: Rakesh | last post by:
Hi, I was 'googling' to look out for some ways of optimizing the code and came across this term - 'hot / cold splitting'. In short, the discussion is about splitting heavily accessed ( hot ) portions of data structure from rarely accessed cold portions. I haven't used this one myself anytime before, but am interested in learning more about this. Can you please share your experience here, so that I can understand better and this could...
13
1445
by: Thomas Liesner | last post by:
Hi all, i am having a textfile which contains a single string with names. I want to split this string into its records an put them into a list. In "normal" cases i would do something like: > #!/usr/bin/python > inp = open("file") > data = inp.read() > names = data.split()
25
9596
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - Why does parseInt('09') give an error? ----------------------------------------------------------------------- The parseInt function decides what base the number is by looking at the number. By convention it assumes that any number beginning with 0x is Hexadecimal, and otherwise any number beginning with 0 is Octal. To force use of base 10 add a second...
130
6579
by: Daniel Manes | last post by:
I'm baffled. I have a column in a SQL Server Express database called "Longitude," which is a float. When I view the table in a DataGridView, some of the numbers, which only have two decimal places in the database show up with *15* decimal places and are ever so slightly off (in the example in the subject line, by about 2E-15). I'm not doing any operations on this column. It's just running a stored procedure which performs a pretty basic...
2
3268
by: shadow_ | last post by:
Hi i m new at C and trying to write a parser and a string class. Basicly program will read data from file and splits it into lines then lines to words. i used strtok function for splitting data to lines it worked quite well but srttok isnot working for multiple blank or commas. Can strtok do this kind of splitting if it cant what should i use . Unal
11
1799
by: Jason Carlton | last post by:
I'm sure this is an easy one, but I can't seem to find it! I have the date and time as: # Nov 28, 2007, 11:11:14pm $timestamp = 20071128231114; In Perl, I would split this up as: my ($year, $month, $day, $hr, $min, $sec) = $timestamp =~ /(\d{4})(\d \d)(\d\d)(\d\d)(\d\d)(\d\d)/;
0
8801
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8707
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9314
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9174
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9015
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5947
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4464
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4725
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2110
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.