Search found 637 matches

by Victorio
Sun Oct 18, 2015 6:07 am
Forum: Xbase++ 2.0
Topic: C language and Xbase
Replies: 20
Views: 41380

C language and Xbase

Hi, I have some routines writed in C (Borland C++). Old exe files from 2000 year not run on Windows 8.1 64bit. I mean also on W7 64 bit. Is big problem compile it for running on W7 W8, W10 ? Also, how can it implement as part of Alaska Xbase ? Must be dll file ? In Turbo C or Borland C+ was generati...
by Victorio
Tue Oct 13, 2015 11:20 am
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Re: Processing large database - acceleation

Piotr: yes it is true, 3 times... thanks for notice, this can get me some percentage of time processing.
:)
by Victorio
Mon Oct 12, 2015 6:49 am
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Re: Processing large database - acceleation

About optimalization processing database : I modified source : 1. set exclusive on, and remove rlock() from algoritm 2. modify set order, set only if order changed 3. modify go rec, set only if record number changed 4. put replace with... to one command. (in source I has several rows with replace wi...
by Victorio
Mon Oct 12, 2015 12:21 am
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Re: Processing large database - acceleation

Jimmy, thanks for important informations, I will look functions and sample source. About data, databases is in range of 20 years, structure of database was x-times changed then I must before processing test every dbf file , how structure he has, and then processing. For example one field KPV using t...
by Victorio
Sun Oct 11, 2015 11:32 am
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Re: Processing large database - acceleation

Piotr D, ok, I change this. It is no problem, I can open database exclusive for time of import. Jimmy: about 19years ago,, I tested it, and time search data in TXT file is better as search in DBF , however i must before search decoding file. C utility was very speed. In txt file I am searching "some...
by Victorio
Sat Oct 10, 2015 11:36 am
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Re: Processing large database - acceleation

Jimmy, processing txt file I mean my new project, what I want reprogramming from Ca Clipper. Problem with optimalization is in existing application, but I examine writed things... I am sure information from you, Tom and Roger help me. In new project I have many databases, in DBF, FPT (FoxPro 2.x for...
by Victorio
Fri Oct 09, 2015 12:36 pm
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Re: Processing large database - acceleation

First I must optimalize some operations with set order and recno(), and put several replace command to one. Then will try other things so wrote Roger and Tom (relation and other). Maybe SQL is right way... But I must start work on new project , which will be work with large databases, about 200GB :s...
by Victorio
Fri Oct 09, 2015 12:15 pm
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Re: Processing large database - acceleation

Jimmy: here I wrote only little example, real function is more complicated, here is : ***************************** * FUNCTION FIDSPR1 * && pomocna funkcia pre spracovanie suboru identifikacii ***************************** FUNCTION fidspr1 * pre pokusne tlacitko v nahlade *pre pokus s toolbarom aj b...
by Victorio
Fri Oct 09, 2015 6:02 am
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Re: Processing large database - acceleation

Roger : Process run only once per month, it is import and processing actually data on client PC. He must run this manually and wait until import done. The long wait is not good for the credibility of my application :roll: ADSDBE and SQL I do not know :oops: , must study it... set relation ? must try...
by Victorio
Fri Oct 09, 2015 5:03 am
Forum: Xbase++ Support
Topic: Processing large database - acceleation
Replies: 18
Views: 33680

Processing large database - acceleation

Hi, In my application I processing database with 100000-200000 records. I am using FOXCDX index. Processing is simple, in cycle "do while" are some mathematical operations , and reading information from other tables is this structure see bottom This simple cycle consume lot of time. In example is on...