To much records

normal · Post by **normal** » Fri 06 Oct 2006 15:59

I use a database with more than 15000 records in one Table.

I'm migrating from BDE to MYSQL and replaced TTable with TMYTABLE.

Now application is very slow even when I query for few fields.

TDBLOOKUPLISTBOX, where I show the data, has only 12 rows. Is it possible to limit the datarows and get new data wheen scrolling or searching in TDBLOOKUPLISTBOX?

FetchAll=true because otherwise I get a "Lost connection during query"-error

Antaeus · Post by **Antaeus** » Mon 09 Oct 2006 06:38

Please specify exact version of MyDAC you use.

normal · Post by **normal** » Mon 09 Oct 2006 09:06

I'm using Version 4.30.0.10

Antaeus · Post by **Antaeus** » Mon 09 Oct 2006 09:31

Try to download the last build of MyDAC (4.40.0.19) and test your application in FetchAll=False mode.

normal · Post by **normal** » Mon 09 Oct 2006 11:34

Sorry, bad question. But how to update to new version?

Antaeus · Post by **Antaeus** » Mon 09 Oct 2006 11:48

You can download the last build of MyDAC from registered users area of our site. Please see your registration mail for details.

normal · Post by **normal** » Mon 09 Oct 2006 16:10

Oh,oh,

with the new version I run into errors in rtl70 and dbrtl70.
Delphi Environment shows runtime error.

Returning back to the old version solve the problem.

Antaeus · Post by **Antaeus** » Tue 10 Oct 2006 15:06

Please specify in what kind of application does the problem appear (any application/any application with MyDAC/concrete application) after installing the last build of MyDAC.

normal · Post by **normal** » Tue 10 Oct 2006 20:25

Delphi 7.1 IDE

The problem appears when opening a Datamodul with TMyTables inside Delphi IDE.

Errormessages:
access violation at adress 40006EA8 ... in module 'rtl70.bpl'
and
access violation at adress 40348F92 ... in module 'dbrtl70.bpl'

Closing Deplhi I can see a runtime error 216.

Antaeus · Post by **Antaeus** » Wed 11 Oct 2006 06:36

Please specify if you have any other Core Lab DAC products (ODAC, SDAC, IBDAC) installed on the same IDE.

normal · Post by **normal** » Wed 11 Oct 2006 10:42

No, there are no other Core Lab products

Antaeus · Post by **Antaeus** » Wed 11 Oct 2006 12:58

Possibly MyDAC unintallation was unsuccessful. So, you have some files left from previous version of MyDAC on your hard drive. Try to uninstall MyDAC and remove all the files concerned to it. Then install last build of MyDAC one more time. To remove all vestiges of MyDAC, please follow these instructions:

1) Close IDE
2) Uninstall MyDAC
3) Search for MyAccess.*, DBAccess.*, mydac*.bpl, dac*.bpl etc files at your HDD and delete them
4) Remove from the project directory all files made by compiler and linker
5) Remove from the registry (HKCU\Software\Borland\Delphi\7.0\Known Packages) all the links to MyDAC packages (mydac*.bpl, dac*.bpl)
6) Run IDE and check that it is started without errors
7) Install MyDAC once more

normal · Post by **normal** » Wed 11 Oct 2006 15:38

I uninstalled 4.3 and 4.4. installations but no success with 4.4.

rtl70 and dbrtl70 errors are still there.

4.3 is running.

Antaeus · Post by **Antaeus** » Thu 12 Oct 2006 15:16

Please try to open following files with Delphi with last MyDAC installed and report us in which cases the error appears:
1) VirtualTable demo (VirtualTable.dpr)
2) Lock demo (Lock.dpr)
3) Pictures demo (Pictures.pas) and data module in this demo
4) Data.pas from Pictures demo (do not open the project file itself)
5) your project and data module in it
6) data module of your project (do not open the project file itself)

Also supply us with some information:
1) which version of MyDAC do you use (Trial, Standard or Professional)
2) do you have in the data module of your project any dataset opened in design time

normal · Post by **normal** » Thu 12 Oct 2006 17:35

Version: MyDAC 4.3.0 Delphi 7 Standard

all your demos are runnig without problems.

When I open my data module (lone or with project) at design time, I see the known errors.

I have my own Table class from TMyTable. I testet this component alone in a form and got the same problem. I will test my component.