Re: Help on Nework Speed
Assuming you are using a LAN and not a WAN (You can not use a WAN without the correct remote software) then if it is getting slower with records, then it means that you either have bad indexes in a table in the set (very unlikely, but a rebuild of indexes eliminates this) or you are not using the correct code. It sounds like you are doing queries that are not using LQO, and not doing Finds (which basically just immediately find a value in an index. This is very typical of someone using action scripting, and either choosing the wrong action script action to perform, or doing it in a very bad method. Many action script lines can be very inefficient, and the only way to make them work fast is to convert them to XBasic and fix the generated code.
I've had 100 users constantly entering and searching data in an Alpha Four system with only a 10 megabit network a long time ago, with absolutely no problem. Even the most poorly created queries should be able to handle 10000 records for most uses, but for instant access all queries should be invoking LQO, or better yet, use Finds in the the index. Doing this, then it should not matter how many users you are using, and how many records are in the tables.
Many XBasic functions (such as TABLECOUNT) invoke queries in their operations. If they are not doing LQO (generally because the inputs are not in a form that recognizes an index for LQO or you don't have an index with the correct expression), it will/can be slow.
Finally, a faster CPU/system will not make any difference for bad code. Built-in network cards are not a reason for slowdowns (unless broken). OS software is also not to blame unless an anti-virus program or some type of disk caching system (which could be in the OS) is operating on the data folder.
Originally posted by JetLi
View Post
I've had 100 users constantly entering and searching data in an Alpha Four system with only a 10 megabit network a long time ago, with absolutely no problem. Even the most poorly created queries should be able to handle 10000 records for most uses, but for instant access all queries should be invoking LQO, or better yet, use Finds in the the index. Doing this, then it should not matter how many users you are using, and how many records are in the tables.
Many XBasic functions (such as TABLECOUNT) invoke queries in their operations. If they are not doing LQO (generally because the inputs are not in a form that recognizes an index for LQO or you don't have an index with the correct expression), it will/can be slow.
Finally, a faster CPU/system will not make any difference for bad code. Built-in network cards are not a reason for slowdowns (unless broken). OS software is also not to blame unless an anti-virus program or some type of disk caching system (which could be in the OS) is operating on the data folder.
Comment