<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">
What is the fastest way to search a HanDBase database?
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
You're doing it.
Currently, that's pretty much the fastest way to search a HanDBase database. I do have plans for adding a DBsearch function for just that purpose, but the speed gain would probably be x2 at best.
Under the hood, the PToolboxLib calls the HanDBase app itself and request a database operation (create, read, write, etc). The problem right now is that the HanDBase app itself is terribly slow at doing these operations. HanDBase v2.x was slow, but something went wrong in v3.x and things are now even slower. Hopefully the HanDBase team will get around to speeding up thier 3rd party app interface (which they call "HAPI") sometime in the near future. I would suggest emailing them directly and putting in a request for speeding up thier HAPI interface.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">
Along this line of questioning, I was investigating HB++, is it
possible to use your library with this language?
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
Nope, only PocketC.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">
Or perhaps read HanDBase files directly with HB++?
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
The last I knew, DDH software has not publically released the structure of HanDBase databases. They instead provide this HAPI interface I mentioned earlier to allow 3rd party apps to access these databases through the HanDBase app itself. This allows DDH to completely change the database structure at will without effecting 3rd party apps (which they did in the v2.x to v.3 migration).
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">
I guess what I'm asking is if there is some special way to read these files that your library is using, that I could produce in a faster language (than PocketC).
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
The slowness here is not because of PocketC or the library, it's due to the HanDBase app itself. You will see this slowness with development platform you use (which employs the HAPI interface).
Joe
The PToolboxLib guy.
http://www.geocities.com/retro_01775/PToolboxLib.htm