M
Mike Fechner
Guest
How are clients connected to the DB? AppServer? Self service? TCP? Unless clients are self service, a 32 bit client can connect to a 64 bit DB or AppServer. Von meinem Windows Phone gesendet Von: peggycole Gesendet: 09.09.2014 17:30 An: TU.OE.Development@community.progress.com Betreff: [Technical Users - OE Development] Buffer the whole database Buffer the whole database Thread created by peggycole Hi, One of our customers asked us why we don't put the whole database in memory at start up of the database. His idea is that when the whole database is buffered, his application would be x times faster. We're talking about a database with the size of +/- 35 GB. The applications works with OE 10.2B 32-bit. If we decide to do the buffering we have to move to OE 11 64-bit because the _mprosrve-processes will become bigger then 4GB. The migration to 64-bit would take us some time because of the use of multiple ocx's in the applications. So before we even try to set this up: do you think this is a good idea? IMO it isn't but I want to give it a try if the customer asks for it. Even if it is to proove it's not working. But because of the extra work it will cost considering the ocx's, i'm not very keen to start with this exercise if we know in advance.it will give us no gain. We do have some performance issues in the application and I think it 's better to fix them instead of doing some hocus pocus to cover them. But I want some decent arguments for that ... Another point against making the buffer as big as the database: The buffer has to fill itself initially. We can write queries on all the different tables and indexes after a restart but that just doesn't feel right and I just do not want to do this. Any comments? Kind regards, Peggy Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...