Giant database dbf

This forum is for eXpress++ general support.
Message
Author
User avatar
Auge_Ohr
Posts: 1428
Joined: Wed Feb 24, 2010 3:44 pm

Re: Giant database dbf

#31 Post by Auge_Ohr »

Eugene Lutsenko wrote:In the link txt-base large dimensions: more than 40,000 fields
http://lc.kubagro.ru/Inf1.zip
i have look into your INF1.TXT
to read Data from TXT File is like SDFDBE ... and all are RAW Data ...

Question : are these data "Points" from "Delaunay Triangulation" ?

did you know Var2Bin() / Bin2Var() ?
you can store a (big) Array into Memo up to 2 Gigabyte.

i have 5 FIELDS

Code: Select all

  IF !FILE(datei)
    AADD(field_list,{"NUM"     ,"N",  5,0})
    AADD(field_list,{"DESC"    ,"C",100,0})
    AADD(field_list,{"POINTS"  ,"V",  8,0})
    AADD(field_list,{"TRIANGLE","V",  8,0})
    AADD(field_list,{"RIBS"    ,"V",  8,0})
    DBCREATE(datei,field_list,"FOXCDX")
  ENDIF
as you see i use 3 Memo Type "V" to store/load Array

i think you have to overthink your Database Design ... :whistle:
greetings by OHR
Jimmy

User avatar
Eugene Lutsenko
Posts: 1649
Joined: Sat Feb 04, 2012 2:23 am
Location: Russia, Southern federal district, city of Krasnodar
Contact:

Re: Giant database dbf

#32 Post by Eugene Lutsenko »

You're right, Jimmy!

With this fun feature I did not know. Will consider in the future. But then, when I had to solve this problem, I solved it fast and simple, ie it is effectively. From memory I also certainly experimented. It was missing totally. I had to implement a quick access any cell of the matrix. So I'm not used to this search for index arrays that it would be longer, but more versatile. For the same reason I didn't bother to read database lines (records). Just made a calculated address of the cell that if its size is known to allow almost instant access to its value. It is clear that this topic is endless and you can develop much more effective than me, a universal form of databases, with no restrictions. The idea I expressed. I understand that my implementation is more than modest, and no matter what do not pretend.

Post Reply