I wouldn't rule out any sambar scripting.. Scripting is scripting in my book.. All preference to which is easiest for you to operate in and which one has the features that you are needing.. Mind you that php / mysql has a bit more control and manipulation of data / table design but for the everyday application, any REAL SQL server will be difficult to notice a difference unless your processing millions of records.
Here are some examples of very different usages of Sambar using scripting, dbms, and basic odbc connections.. 1) sambar hooked to access hooked to excel spreadsheet sitting on a novell file server. Actually performs pretty fast.. Of course you can tell there is a bit of lag between access and the spreadsheet as the novell box is hooked via NW Gateway services over IPX. One of those read only jobs on this one. It works and under 1sec response time. 2) sambar hooked to access hooked to access database sitting on another microsoft server.. This runs pretty good but on large queries you can feel a delay as the real data is still having to pass over the network. 3) sambar hooked to access on the same machine.. This smokes.. and all around performs great.. Since everything is local to the machine, you won't notice much slowdown from the servers perspective up to around 100,000 records or so, assuming you write your queries properly, index and key everything. 4) sambar hooked to SQL server.. Well I shouldn't brag too much on this box because the server itself makes the difference with this guy.. Having 2gigs of memory on board with 4gigs of CPU cache on 2 zeon processors kinda helps... Needless to say.. I can't make this thing slowdown. For 500,000 records I think its a waste of money. 5) sambar hooked to mysql on a really crappy processor.. Honestly, I think mysql would outrun SQL server given that they were on the same box.. mysql smokes and is an awesome true SQL server, php or no php.. I would only recommend using dbtools(www.dbtools.com.br) to manage it.. Really take the headaces out of desiging your tables and security.. Looking at MS SQL Enterprise manager, this dbtools team must have worked for MS sometime :) All of these items are using basic sambar scripting with dbms / odbc and personally with the traffic I see I couldn't image needing to jump to leaps and bounds to get off of any of them. They all perform plenty fast enough for the bandwidth that they are demanded to serve. As for my overall suggestion, I recommend taking the easiest way out and of course ensuring that it will handle the amount of work you require from it. My 10 cents. Danny On 16/Jul/2002 10:09:38, Michael Cook wrote: > 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 <A TARGET="_blank" >HREF="http://www.dbase.com";>http://www.dbase.com</A> 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 <A TARGET="_blank" >HREF="http://www.sambar.ch/list/";>http://www.sambar.ch/list/</A> > > > > > > > > -- > Best regards, > Dave <A >HREF="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]</A> > ------------------------------------------------------- > To unsubscribe please go to <A TARGET="_blank" >HREF="http://www.sambar.ch/list/";>http://www.sambar.ch/list/</A> > ------------------------------------------------------- > To unsubscribe please go to <A TARGET="_blank" >HREF="http://www.sambar.ch/list/";>http://www.sambar.ch/list/</A> > > > > > ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
