Michael
I use stm scripting and mySQL almost exclusively.
Peter
----- Original Message -----
From: "Michael Cook" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 10:09 AM
Subject: [sambar] Increasing dbms Performance {03}
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/
-------------------------------------------------------
To unsubscribe please go to http://www.sambar.ch/list/
