Re: Speed issue...


About 30 fields, number and text. No blobs, no long strings.
It is constantly slow. I am also using CalcFields event and turning
that off speeds things up by 2x when scrolling the database. Instead
of 1 second it takes about 0.5 seconds to move to the next record.

Each scroll operation executes a new Locate call with 2 indexed fields on
a database with about 3000 records.

DataForm.Table.Locate('LoID;CoID', VarArrayOf([DataForm.LTable['ID'],
DataForm.CTable['ID']]),[]);

Thats where the 0.5 second comes from. All tables here are TAdoTable.

The CalcFields fills four Calculated fields with the sum of 3 other number
fields
from the same record. This is the other 0.5 seconds of the .Next call cost.

Making an edit is as slow as I mentioned.

Since you are using TadoTable try turning the TableDirect property to True.
This will have Access use an internal cursor instead of generating a Select
statement. This is faster for Access. You can also try replacing your Locates
with Seek if the fields you are locating on are indexed.
Also try disableControls on the table you are locating on and Enablecontrols
after the locate if you have any controls connected to these tables.
DisableControls adds some speed when moving records even if there are no
controls attached.
If there are any detail tables connected to the table you are scrolling you
might want to disable controls on them to especially if they are not visible.


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Achieving very smooth scrolling of large data sets?
    ... > better to do, and pruning your cache. ... However when the database is stored on a network server, ... you saying to exploit the relative low sensitivity of scrolling by ... scrollbar (a screen rarely being more than 1024 pixels high)? ...
    (comp.lang.java.databases)
  • Search Form
    ... you didn't say how you were searching and scrolling so i ... the only thing that comes to mind is the distinct word. ... >database stores is very simple information, ...
    (microsoft.public.access.formscoding)
  • Re: Deep Forest Amchair
    ... Larry Jaques ... I'm turning, ... scrolling and carving and nothing for near that price. ...
    (rec.woodworking)
  • Re: Mouse Wheel and Combo Boxes
    ... the mouse wheel for scrolling through the offerings of a combo-box. ... Our original database was developped by another guy ... In addition how do the users cope with standard Windows applications ...
    (comp.databases.ms-access)
  • Re: Dynamic display of Text Ticker on Windows Desktop
    ... Have you created a theme for your desktop that uses the scrolling / dynamic text? ... Does it query the web site for the information. ... > I need to display the contents of my MS Access database file on the ... If possible kindly help me as soon as possible, as my website is ...
    (microsoft.public.frontpage.addins)