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/



Reply via email to