Slow Process

[taniarto jeannica]

Dear All,

I'm using Clarion 6.3 and SQL Server 2005 as database. And now my data
record is about 63.000 record. I Have some problems according those
number of record. The problems are :

- When I browse those records from browse menu it takes about 5-10
second to show all of the record (quite slow)
- When OK button were selected to save record the process run quite
slow (taking 5-6 seconds) until browse menu data are ready to take
another command (Insert,change, or delete)

Can not imagine what would be happened cause the record will turn
bigger everyday.
Please any one tell me an information about tuning the problems can go
faster.

Thanks

Joe

 

[Ian Collins]

Dear All,

I'm using Clarion 6.3 and SQL Server 2005 as database. And now my data
record is about 63.000 record. I Have some problems according those
number of record. The problems are :

- When I browse those records from browse menu it takes about 5-10
second to show all of the record (quite slow)
- When OK button were selected to save record the process run quite
slow (taking 5-6 seconds) until browse menu data are ready to take
another command (Insert,change, or delete)

Do you have a C++ question?