The Ideas Genie Community Forum

Bank Genie => General discussion => Topic started by: mikec on October 09, 2025, 02:21:36 PM

Title: Bank Genie Review
Post by: mikec on October 09, 2025, 02:21:36 PM

I now have 30,886 transactions on Bank Genie, a testament to the robustness of your product. The software is used every day of the week since I bought the product in 2015.

MikeC

Title: Re: Bank Genie Review
Post by: ideasguy on October 10, 2025, 10:09:33 AM

I am amazed Mike. Ive been using Bank Genie (http://www.bankgenie.net) long before I released it to the public and I have 31667 records in my database.
You must have imported a large number of transactions from your previous Personal Finance Software when you switched to Bank Genie.

Heres some stats about the software I use for development:
Maximum # of records per table file.
 1 billion
 
Maximum size of a table file.
 2 gigabytes
 
Maximum size of an FPT file.
 2 gigabytes
 
Maximum # of characters per record.
 65,500
 
Maximum # of fields per record1.
 255
 
Maximum # of tables open at one time2.
 65,535
 
The table with Bank Genie transactions is called TRANS.dbf
I dont think anyone will exceed its capability.
Our 30,000 or so records is a drop in the ocean compared to the max number of 1 billion   :D

Title: Re: Bank Genie Review
Post by: barryl on October 23, 2025, 10:40:55 AM

I first tried Bank Genie in 2007. Since then I have kept up with the changs of release and even collaborated with George on some developments. I now have 10 (TEN!) different databases reflecting the different financia responsibilities I have. I just looked and the largest dataset (my own finances) dates back to 1993 and has over (wait for it....) 61000 records.

Title: Re: Bank Genie Review
Post by: ideasguy on October 23, 2025, 11:22:25 AM

That is amazing Barry!

Try this:
Using Transaction Analyser, RIGHT click on the From date date picker field and choose the option "From = Very First Date".
RIGHT click on the TO date date picker field and choose the option "To = Very Last Date".
It may take a few seconds, but does it display ALL transactions OK?
Ive never tried with such a large dataset.