Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-18 Thread Michael Van Canneyt
On Wed, 18 Jul 2007, Martin Schreiber wrote: On Tuesday 17 July 2007 23.58, Joost van der Sluis wrote: So this makes your case, doesn't it. Martin argued that his dataset was designed to work together with his visual controls. Yes, but it's an important part, because exactly this is

[fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Joost van der Sluis
Hi all, To see what the differences in speed are between MSEdb and fcl-db I did some benchmarks. (See the attachment for the code and results) I think that the first conclusion is that when it comes to executing queries, opening connections to the database and such, the 'real sql- work' there's

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Martin Schreiber
On Monday 16 July 2007 14.20, Joost van der Sluis wrote: Hi all, To see what the differences in speed are between MSEdb and fcl-db I did some benchmarks. (See the attachment for the code and results) [...] I tried to explain the readdata-difference. At first I thought that msedb converted

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Michael Van Canneyt
On Mon, 16 Jul 2007, Joost van der Sluis wrote: Hi all, I tried to explain the readdata-difference. At first I thought that msedb converted all strings from string to widestring to string. But it doesn't do that. (see my mails on this subject) I think that the only reasonable

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Michael Van Canneyt
On Tue, 17 Jul 2007, Martin Schreiber wrote: On Monday 16 July 2007 14.20, Joost van der Sluis wrote: Hi all, To see what the differences in speed are between MSEdb and fcl-db I did some benchmarks. (See the attachment for the code and results) [...] I tried to explain the

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Joost van der Sluis
On Tue, 2007-07-17 at 09:40 +0200, Martin Schreiber wrote: On Monday 16 July 2007 14.20, Joost van der Sluis wrote: Hi all, To see what the differences in speed are between MSEdb and fcl-db I did some benchmarks. (See the attachment for the code and results) [...] I tried to

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Joost van der Sluis
On Tue, 2007-07-17 at 10:41 +0200, Michael Van Canneyt wrote: On Mon, 16 Jul 2007, Joost van der Sluis wrote: Hi all, I tried to explain the readdata-difference. At first I thought that msedb converted all strings from string to widestring to string. But it doesn't do that. (see

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Vincent Snijders
Joost van der Sluis schreef: If you know a way to measure that using linux? It should be possible, the shootout ppl also do this. http://shootout.alioth.debian.org/gp4/faq.php#memory Maybe you can poll /proc/$PID/status Vincent ___ fpc-pascal

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Michael Van Canneyt
On Tue, 17 Jul 2007, Vincent Snijders wrote: Joost van der Sluis schreef: If you know a way to measure that using linux? It should be possible, the shootout ppl also do this. http://shootout.alioth.debian.org/gp4/faq.php#memory Maybe you can poll /proc/$PID/status Why not simply

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Joost van der Sluis
On Tue, 2007-07-17 at 19:58 +0200, Coco Pascal wrote: Joost van der Sluis wrote: Discussion: What tests could I do more? Is there something I overlooked? To me it seems that benchmark tests on 10 records are missing relevance more and more. Offcourse, but it has some usefull

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Daniël Mantione
Op Tue, 17 Jul 2007, schreef Coco Pascal: Joost van der Sluis wrote: Discussion: What tests could I do more? Is there something I overlooked? To me it seems that benchmark tests on 10 records are missing relevance more and more. I'm interested in responsiveness in n-tier

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Coco Pascal
Daniël Mantione wrote: Op Tue, 17 Jul 2007, schreef Coco Pascal: Joost van der Sluis wrote: Discussion: What tests could I do more? Is there something I overlooked? To me it seems that benchmark tests on 10 records are missing relevance more and more. I'm interested in

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Coco Pascal
Joost van der Sluis wrote: On Tue, 2007-07-17 at 19:58 +0200, Coco Pascal wrote: Joost van der Sluis wrote: Discussion: What tests could I do more? Is there something I overlooked? To me it seems that benchmark tests on 10 records are missing relevance more and more.

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Joost van der Sluis
On Tue, 2007-07-17 at 21:27 +0200, Coco Pascal wrote: Joost van der Sluis wrote: On Tue, 2007-07-17 at 19:58 +0200, Coco Pascal wrote: Joost van der Sluis wrote: Discussion: What tests could I do more? Is there something I overlooked? To me it seems that benchmark tests on

Re: [fpc-pascal] msedb and fcl-db benchmarks

2007-07-17 Thread Martin Schreiber
On Tuesday 17 July 2007 23.58, Joost van der Sluis wrote: So this makes your case, doesn't it. Martin argued that his dataset was designed to work together with his visual controls. Yes, but it's an important part, because exactly this is the part that has changed. Except from this and the