Thanks Peter and Dave for your responses. The data sits in DBF tables. The tables are not that particularly large (the largest has 78,000 records, and most others only have 1000 - 2000.
I've been looking into DB2K http://www.dbase.com as it looks like a promising toolset. I wanted to stay with stm scripting for now, but there is lots of support out there for going to PHP and mySQL, as Peter mentioned. Michael >>> [EMAIL PROTECTED] 07/15/02 06:00PM >>> Hello Michael, What database are you using? I know alot of people use MS Access, but I'd advise against it. Yes, I do use it on my site, but only because it's the db used for a particular application (Legacy Family Tree) and I just publish that. The thing that most people do not realize about Access is that it's not really a relational database. It uses flat files, and to extract information the program must load the entire table into memory, get the info it wants, then throw away the rest. A true RDBMS only fetches the info you request. So switching to another DB will give you the biggest improvement. Monday, July 15, 2002, 12:11:58 PM, you wrote: MC> After reading how to increase Sambar performance in the docs (increasing web performance and dbms performance), are there any other "tips" that would further tweak dbms performance. I've got MC> Sambar 5.1 on W2K and I am using MS ODBC version 4.0.x DBF drivers. MC> Thanks. MC> ------------------------------------------------------- MC> To unsubscribe please go to http://www.sambar.ch/list/ -- Best regards, Dave mailto:[EMAIL PROTECTED] ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/ ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
