Prev: Vulcan Advantages (was Choice SQL Database)
Next: mySQL_msSQL_Oracle connection and other relations / ALL command
From: Marc Verkade [Marti IT] on 6 Dec 2008 13:59 9 seconds is much.. I have no clue about the difference havind the exe local of networked. That sounds strange to me too! I would consider ADS Local server.. It is free and i am sure it will save you several seconds! Fuirthermoe I found that the switch 'generate source' for texts on tabpages has influences for speed. WHen set to 'no' the windows load much faster because only reaources are used and no code. You could give that a try too. -- Grtz, Marc "Dirk (Belgium)" <dirk.dot.herijgers(a)pbprojects.dot.be> schreef in bericht news:KFc_k.16188$uy1.3675(a)newsfe23.ams2... > Alessandro Antonangeli wrote: > >> There may be a lot of causes >> The firsts than comes to my mind are >> there are some SetFilter: they are terribly slow over a network and >> DBF has a lot of records you use a lot of objects and you go near the >> limit of memory of the program: try increasing the moemory available >> to the program try using the dbf locally also to see if this may be >> the problem > > Hi Alessandro, > > I think you don't understand the problem (or I have not explain it well) > > In both cases; the data is placed on a share on a server > But, in first case, the EXE and DLL are local: Then it takes 9 secondes > And, in second case, the EXE and DLL are on the network: It takes 14 > secondes. > > I believe it can nothing have to do with the way you access your data. > It must have to do something how Microsoft handles reading "EXE's" and > "DLL's" over a network... > > Dirk > > -- >
From: Geoff Schaller on 6 Dec 2008 18:52 Dirk, Didn't we answer you in the other forum? If you are going to cross post it is going to get tedious. Perhaps you should just stick to this forum, the main VO forum. It certainly has a lot more readers. The problem has NOTHING to do with Microsoft and will have nothing to do with the network unless you did something weird with it. For instance. Let us say they have a standard 100MB LAN and your exe is a huge 20MB. Bytes and bits aside, care to calculate how long it will take to copy and load the exe? Around 1.6 seconds, all things being equal. Now on a standard modern GB LAN with a switching hub, it is sub second. Assuming you don't have irrelevant protocols and that all workstations are XP SP3 or Vista, this is not your problem. You need to look to your code and the design of your windows. We have plenty of customers that open EXEs across the network and it is all sub second stuff. Back to the drawing board my boy... tell us more about the design of the app. Also, which bit is actually slow. Any app that takes 9 seconds to open is in dire need of some work. Geoff "Dirk (Belgium)" <dirk.dot.herijgers(a)pbprojects.dot.be> wrote in message news:KFc_k.16188$uy1.3675(a)newsfe23.ams2: > Alessandro Antonangeli wrote: > > > > There may be a lot of causes > > The firsts than comes to my mind are > > there are some SetFilter: they are terribly slow over a network and > > DBF has a lot of records you use a lot of objects and you go near the > > limit of memory of the program: try increasing the moemory available > > to the program try using the dbf locally also to see if this may be > > the problem > > > Hi Alessandro, > > I think you don't understand the problem (or I have not explain it well) > > In both cases; the data is placed on a share on a server > But, in first case, the EXE and DLL are local: Then it takes 9 secondes > And, in second case, the EXE and DLL are on the network: It takes 14 > secondes. > > I believe it can nothing have to do with the way you access your data. > It must have to do something how Microsoft handles reading "EXE's" and > "DLL's" over a network... > > Dirk > > -- __________ Information from ESET NOD32 Antivirus, version of virus signature database 3668 (20081206) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com
From: richard.townsendrose on 7 Dec 2008 09:40 Dirk we have always set the "No access/assign" to "Yes" [wrong english usage but never mind - it should be "Create Access Assign" "No"] and using ADS gives huge improvements. If you want to filter on a field, then include that field in an index will make it faster as well ... Richard
From: Marc Verkade [Marti IT] on 7 Dec 2008 10:36 nope, generate code for texts.. that is what i mean. -- Grtz, Marc "richard.townsendrose" <richard.townsendrose(a)googlemail.com> schreef in bericht news:7bbd5578-83d5-4001-bb1e-db847b029dd8(a)v38g2000yqb.googlegroups.com... > Dirk > > we have always set the "No access/assign" to "Yes" [wrong english > usage but never mind - it should be "Create Access Assign" "No"] > > and using ADS gives huge improvements. If you want to filter on a > field, then include that field in an index will make it faster as > well ... > > Richard
From: Dirk (Belgium) on 8 Dec 2008 03:37
Geoff Schaller wrote: > Dirk, > > Any app that takes 9 > seconds to open is in dire need of some work. > > Geoff > > > Geoff, This is what I want to say: The app is already loaded !!! 14 seconds is the time to open a specific childwindow, when EXE and DLL's are on network, but 9 seconds when EXE and DLL's are local (data is always network). Even opening this childwindow a second time, the difference in time still exist. Dirk -- |