Someone could extend the DataSourceJDBC class with a sort of caching - just an idea. Or use classic navigation. Or even the best - reevent (beause the knowlegde of of it's work is lost in space) the classic navigation and let it work together with the Datalist classes.
Just some thoughts ...... Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von > Contacta Development > Gesendet: Montag, 2. August 2004 17:09 > An: dbf interest > Cc: Shawn > Betreff: Re: [dbforms] dbForms Performance > > By now we are using version 2.3 on production systems, and we have > dealed around > 25 million rows but doing filtering or using whereClause, and > avoinding navigation. But on smaller tables (around 10.000 > rows) I can't use navigation without "Out of Memory" problems (even > using filtering or whereClause) if I want to use navigation buttons at > the same time. So How can I use navigation buttons at the same time I > have big tables and use filtering or whereClause? > > Currently my server is dual Xeon with 1.5Gb RAM, and external > DataBases (Postgresql, MySQL, MS SQLServer). > > -- > > Alfred Certain > Contacta CRM Development Group > www.contactacrm.com > > > Mensaje citado por Shawn <[EMAIL PROTECTED]>: > > > > > > Our company has developed a whole CRM using dbForms and > has been in > > production > > > for around 1 year, but now we are having perfomance problems with > > > big > > tables. > > > > Are you using 1.1.4 or later with the DataListNavigation > system? It > > is the default since around 1.1.4 -- maybe 1.1.4pr2 or so. > Anyway, it > > is known to cause performance problems with big tables if > you do not > > have sufficient memory. The solution would be to go back > to classical > > nagivation. See the chapter on Navigation under Major New > Features. > > Geez maybe that should be moved into its own section since > it isn't really new anymore... > > > > Also, in tableData and related tags, you may want to > disable the cache > > if again memory is scarce. > > > > Another thing I do with a table that has 165,000+ rows is use thes > > DataListNavigation but to filter the query before it is run > the first > > time so the rsv that gets stored is managable memory wise. > Otherwise > > with no filter I need classic navigation to avoid a three > minute wait. > > > > -- > > Shawn > > > > Karma is immutable, so act accordingly! > > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by OSTG. Have you noticed > the changes > > on Linux.com, ITManagersJournal and NewsForge in the past > few weeks? > > Now, one more big change to announce. We are now OSTG- Open Source > > Technology Group. Come see the changes on the new OSTG site. > > www.ostg.com _______________________________________________ > > DbForms Mailing List > > > > http://www.wap-force.net/dbforms > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by OSTG. Have you noticed the changes > on Linux.com, ITManagersJournal and NewsForge in the past few weeks? > Now, one more big change to announce. We are now OSTG- Open Source > Technology Group. Come see the changes on the new OSTG site. > www.ostg.com _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms > ------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
