(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › [Solved] Moving between records slowdown
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic [Solved] Moving between records slowdown (Read 1477 times)
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
[Solved] Moving between records slowdown
Jul 19th, 2007 at 6:37pm
Print Post Print Post  
I am really enjoying the Sesame 2.0 program. 

That said, I am noticing that when switching between records using either F9/F10 or the Record Navigation controls, there is a 1.5 to 2 second delay before the next/previous record displays.  I thought this might be because of the large amount of programming I have in this database.  I made a backup copy and deleted all programming.  This changed nothing (at least not that I could notice).  So my next thought was it might be the fact that we have almost 10,000 records with hundreds of elements/fields each.  So I deleted all but 90 records.  Again no speed increase. 

Any suggestions/reasons why this might be slow? 

I do have 11 tab pages - could that do it?

Thanks
« Last Edit: Oct 16th, 2007 at 9:06pm by Hammer »  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Moving between records slowdown
Reply #1 - Jul 19th, 2007 at 6:51pm
Print Post Print Post  
Do you have subforms?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Moving between records slowdown
Reply #2 - Jul 19th, 2007 at 7:52pm
Print Post Print Post  
One - with two fields on it.   No data in any of the records yet.
  
Back to top
 
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Moving between records slowdown
Reply #3 - Jul 19th, 2007 at 8:05pm
Print Post Print Post  
I deleted the subform and it did cut the time to about 3/4 of a second between records.  That is much more acceptable as far as time goes, but not very acceptable if you need/want a subform.

Undecided
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Moving between records slowdown
Reply #4 - Jul 19th, 2007 at 8:34pm
Print Post Print Post  
CapitalG wrote on Jul 19th, 2007 at 8:05pm:
I deleted the subform and it did cut the time to about 3/4 of a second between records.  That is much more acceptable as far as time goes, but not very acceptable if you need/want a subform.


Subforms in general are not a problem.

Is there programming in the subform?

Is the subform using relational or natural linking?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Moving between records slowdown
Reply #5 - Jul 19th, 2007 at 8:44pm
Print Post Print Post  
There was no programming in the subform.  It is using Natural Linking.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Moving between records slowdown
Reply #6 - Jul 19th, 2007 at 9:29pm
Print Post Print Post  
Send it into Support. We'll put it into the testbed and see what is taking the time.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Moving between records slowdown
Reply #7 - Jul 19th, 2007 at 9:43pm
Print Post Print Post  
Thanks,

I will send it in.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Moving between records slowdown
Reply #8 - Jul 23rd, 2007 at 7:27pm
Print Post Print Post  
Just a follow-up:

The problem turned out to be running Sesame locally on one computer and having the DB and DAT files stored on the hard drive of another computer and not running Sesame as a Client/Server setup.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
charliebrown
Junior Member
Members
**
Offline


Beware...novice at large

Posts: 97
Location: Sacramento, CA
Joined: Apr 19th, 2006
Re: Moving between records slowdown
Reply #9 - Oct 16th, 2007 at 9:04pm
Print Post Print Post  
Quote:
Just a follow-up:

The problem turned out to be running Sesame locally on one computer and having the DB and DAT files stored on the hard drive of another computer and not running Sesame as a Client/Server setup.

-Ray


I've resembled that problem...we've been waiting for "approval" to run Sesame in clent/server.  Though I never had a problem, one person had this happen storing DB and DAT files on our public access drive...we were also using relational linking, which I'm changing and testing as I add more functions to our application.
« Last Edit: Oct 17th, 2007 at 3:28pm by charliebrown »  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge