Author Topic: Bank Genie Review  (Read 837 times)

ideasguy and 11 Guests are viewing this topic.

Offline mikec

  • Newbie
  • *
  • Posts: 1
Bank Genie Review
« 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

Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6355
  • Just me
    • Ideas for Gardens
Re: Bank Genie Review
« Reply #1 on: October 10, 2025, 10:09:33 AM »
I am amazed Mike. Ive been using Bank Genie 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
« Last Edit: October 10, 2025, 10:11:06 AM by ideasguy »

Online barryl

  • Senior Member
  • ****
  • Posts: 252
Re: Bank Genie Review
« Reply #2 on: Yesterday at 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.


Online ideasguy

  • Administrator
  • Hero Member
  • *****
  • Posts: 6355
  • Just me
    • Ideas for Gardens
Re: Bank Genie Review
« Reply #3 on: Yesterday at 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.