J... OK, got it. I will cross that bridge when I come to it.
Thanks, Craig On Jan 3, 2009, at 1:59:04 PM, "J. Landman Gay" <jac...@hyperactivesw.com> wrote: From: "J. Landman Gay" <jac...@hyperactivesw.com> Subject: Re: Large databases kaput? Date: January 3, 2009 1:59:04 PM EST To: "How to use Revolution" <use-revolution@lists.runrev.com> dunbarx wrote: > Thanks for the reply, but not that. I heard on another thread that there > was a Rev issue with large stacks, 5000+ cards. I wanted feedback before > I made a test stack to check it out. Is it a matter of navigation, > finding stuff, open/close or what? As Bjoernke mentioned, it's mostly a question of speed. Rev doesn't have HC's hintbits (and can't; it is proprietary info) and so searches need to look at every text block to accomplish a find. If your stack doesn't rely on "find" (or you don't mind waiting) then you can get away with much larger stacks. If you need to navigate to a particular card quickly, creating your own index using card IDs is the fastest way to manage it. Card IDs are faster than any other type of card access. Rev is entirely RAM-based, so if your stack is tens of megabytes in size it will take longer to load it all than a smaller stack. If you do not have enough available RAM to hold the entire contents, speed will also be affected by the required disk paging to virtual memory. The 5000 card number is a very gerneric estimate only. A stack with a single field on each card can remain responsive even with many more cards than that. If each card has many fields, the number is lower. I've had stacks with ~8000 cards that worked okay (though a bit sluggishly) because each card shared a background with only 2 fields containing very little data. If you have a specific stack in mind, I'd say to convert it and see how it does. Each one will behave differently depending on the objects on the cards and how you need to navigate. -- Jacqueline Landman Gay | jac...@hyperactivesw.com HyperActive Software | http://www.hyperactivesw.com _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution