[mapguide-users] perfomance test

[Jason Birch]

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/61e21972/attachment.html