Re: slow startup on windows

If I go with SQLite I'd have to rewrite my entire code. I've been
doing this for 25 years...back then there wasn't a cross-platform
DB available (or at least I didn't know of one).



-----Original Message-----
From: Roland Hughes via Foxgui-users
<[email protected]> 
Sent: Friday, October 25, 2024 10:42 AM
To: [email protected]
Subject: Re: [Foxgui-users] slow startup on windows

Everyone needs to keep an i5-gen3 around for testing.

Your application doesn't run well until it runs well on that with
a SATA
100 or 150 spinning disk. You can probably get the HP small form
factor ones from a recycler for under $50 if you promise not to
throw it in a landfill.

I recommend SQLite because it is "everywhere" and you get SQL
access. In the old days we used indexed files. Used to be
C-Index/II and some commercial XBase libraries along with
Btrieve, etc. There is an OpenSource XBASE library

https://sourceforge.net/projects/xdb/files/


On 10/25/2024 9:27 AM, Enno Rehling wrote:
> I second what Roland says, don't load all those strings into
memory, 
> or at least not into FXString objects, if you can at all help
it.
>
> Now, there's a chance you've got the strings in a big file that
is NOT 
> a relational database, and you need to search through them in
some 
> form. That still doesn't mean they all need to be an FXString
(unless 
> you plan to display each and every one of them in a widget).
Memory 
> allocation via new or malloc is expensive (more so with poorly
written 
> allocators or on certain operating systems), and you want to
avoid it 
> as much as you can.
>
> Depending on your input file format, perhaps you can just mmap
[1] 
> that file into memory and index it in some other way? Of course
then 
> you need to write custom code for Windows [2], because the
WIN32 API 
> is special.
>
> Enno.
>
> References:
> [1] https://www.man7.org/linux/man-pages/man2/mmap.2.html
> [2] 
>
https://learn.microsoft.com/en-us/windows/win32/memory/file-mappi
ng
>
>
>
> _______________________________________________
> Foxgui-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/foxgui-users

--
Roland Hughes, President
Logikal Solutions
(630)-205-1593  (cell)
https://theminimumyouneedtoknow.com
https://infiniteexposure.net
https://johnsmith-book.com



_______________________________________________
Foxgui-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/foxgui-users