Search found 637 matches
- 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...
- 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.
![Smile :)](./images/smilies/icon/smile.gif)
![Smile :)](./images/smilies/icon/smile.gif)
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...