Hi Clovis, > -----Original Message----- > From: Cl�vis Wichoski [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 3. M�rz 2005 21:32 > To: Maxdb > Subject: tip of SAPDB parameters to achieve best performance on a > machine. > > > Hi, > > Here I have a SapDB 7.3.40 installed and running on a RedHad > Linux with > a Dual XEON (HT) 2.8G processor, 2GB of RAM, and I have > doubts, on how > to best configure the parameters to achieve the best > performance in this > machine. > The database runs alone in this, machine. > > any tip? > how much sessions or users this configuration support?
These questions are too general. What sessions do you mean? Data mining or querying one simple select? As one of the most general rules, you can take this one: Minimize I/O. For setting DB-parameters, you have to read the documentation. E.g. if the database should use both CPUs, consider the MAXCPU parameter. MAXUSERTASK and CACHE_SIZE are probably also of great interest. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP AG, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.mysql.com/products/maxdb www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
