D6 update patch 1+mysql 5.0. using dbexpress

[Alex L]

Dear Sir,

I use D6 update patch 1+mysql 5.0. using dbexpress

Here is the setup:
SQLConnection
|-- SQLdataset
|-- DataSetProvider
|-- ClientDataSet
|-- Datasource

The table have more that 60000 records.
In ClientDataSet , I set the packetrecords = 1 to speed up the time to open
the table. and I use the
"ClientDataSet1.FindNearest([trim(Edit1.Text)]);" as findkey the record.
but the programs try to load
the dataset into the memory and the system resource are eat up by the
dataset.

How can I to pervent those happen? Thanks.



the programs

[Alex L]

Also , I got the same problem in use interbase 5.0 as database . I know
mysql can control the selection record count and record order by query. how
about in interbase

Thanks

Post by Alex L
Dear Sir,
I use D6 update patch 1+mysql 5.0. using dbexpress
SQLConnection
|-- SQLdataset
|-- DataSetProvider
|-- ClientDataSet
|-- Datasource
The table have more that 60000 records.
In ClientDataSet , I set the packetrecords = 1 to speed up the time to
open the table. and I use the
"ClientDataSet1.FindNearest([trim(Edit1.Text)]);" as findkey the record.
but the programs try to load
the dataset into the memory and the system resource are eat up by the
dataset.
How can I to pervent those happen? Thanks.
the programs
--
Regards
Alex Leung

[Bill Todd]

If you want to find a record close the CDS, change the SQL SELECT
statement so the WHERE clause contains the criteria for the record you
want then reopen the CDS. You should always use SQL to select the
records you want. You should not load the entire table into memory in
the CDS and search the CDS.

[Alex L]

Dear Bill,

Thanks for reply.

I have application with interbase 5.0. windows server.
How to use the CDS to control the record order number in "select "
statement?

Mysql can control the selection record count and record order by query. (Add
limit X,Y at the end of query)
how about it in interbase?

Also , do you have some suggestion in using CDS in replacing the method in
"Findnearest" and "locate" at Ttable?

Thanks

Post by Bill Todd
If you want to find a record close the CDS, change the SQL SELECT
statement so the WHERE clause contains the criteria for the record you
want then reopen the CDS. You should always use SQL to select the
records you want. You should not load the entire table into memory in
the CDS and search the CDS.
--
Bill Todd (TeamB)

[Bill Todd]

Post by Alex L
I have application with interbase 5.0. windows server.
How to use the CDS to control the record order number in "select "
statement?

The current version of InterBase supports the SQL standard ROWS clause,
however, this feature was not available in IB 5.0. The only way to
return the first N rows in IB 5 is to write a stored procedure and pass
the number of rows you want to the stored procedure in an input
parameter.

Post by Alex L
Mysql can control the selection record count and record order by
query. (Add limit X,Y at the end of query) how about it in interbase?
Also , do you have some suggestion in using CDS in replacing the
method in "Findnearest" and "locate" at Ttable?

See http://community.borland.com/article/0,1410,28160,00.html and if
you still have questions ask. Hope this helps.