[mapguide-users] perfomance test

[Haris Kurtagic]

Here MG is not involved, I have written FDO client application which is
querying against FDO providers ( in a same way MG is doing).
So in results is no MG overhead.
This test is really very unfavorable to Oracle. But even comparing in
this way in my opinion differences are not that big, specially when you
add other overheads on it.
And there are a huge benefits in putting spatial data in database.
 
I think he doesn't know. This tool will be freely available, and that
would be good to see to test PostGIS.
 
Yes this is essentially comparison of king.oracle provider with other
providers not database itself .
 
P.S. Thank you, I didn't know that
 
Haris

________________________________

From: Jason Birch [mailto:Jason.Birch at nanaimo.ca] 
Sent: Sunday, October 29, 2006 11:18 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] perfomance test


Haris,
 
Those are some really interesting results.  I'd like to see what happens
with spatial index optimisation, but I am mostly wondering why it took
so much longer to pull all features/attributes, where index optimisation
would not have any effect.  Was the database server running on the same
box as MapGuide?  I'd also like to see what happens with some attribute
filters against a database that has proper column indexes created on it.
 
What I found most interesting though is that you're working on some
commandline tools for FDO.  That is something that is sorely needed.  An
fdo2fdo tool would be nice too.  Does Mateusz know that you're working
on this?  He was looking for some schema-ized data to test the PostGIS
provider against a couple days ago and I didn't have any.  I'd also love
to see the same kind of performance comparisons run against the PostGIS
provider when it's available, and some profiling run against the code to
see where most of the time is being spent (in fdo, network, or
database).
 
Jason
 
P.S. This kind of comparison might be OK if you are comparing the King
provider's performance against the SDF provider's performance, but be
careful about publishing performance tests for Oracle.  Their corporate
lawyers don't like this kind of thing at all.  Apparently there's a
clause in the EULA...


________________________________

From: Haris Kurtagic
Sent: Sunday, October 29, 2006 13:58
To: users at mapguide.osgeo.org
Subject: [mapguide-users] perfomance test


Test case 1: No geometry filter, Fetch all attributes 
 
SDF        0.937 
SHP        8.531 
10GR2    18.172
XE            18.500
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061029/3b5dcf1d/attachment.html