<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2>Here MG is not involved, I have written FDO client
application which is querying against FDO providers ( in a same way MG
is doing).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2>So in results is no MG overhead.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2>And there are a huge benefits in putting spatial data
in database.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2>I think he doesn't know. This tool will be freely
available, and that would be good to see to test PostGIS.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006></SPAN><SPAN
class=453181922-29102006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2>Yes this is essentially comparison of king.oracle provider
with other providers not database itself .</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2>P.S. Thank you, I didn't know that</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=453181922-29102006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Jason Birch
[mailto:Jason.Birch@nanaimo.ca] <BR><B>Sent:</B> Sunday, October 29, 2006 11:18
PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] perfomance test<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2>Haris,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2>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).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2>Jason</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=166210422-29102006><FONT face=Arial
color=#0000ff size=2>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...</FONT></SPAN></DIV></SPAN></DIV><FONT face=Arial
color=#0000ff size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><FONT
face=Arial color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic<BR><B>Sent:</B> Sunday,
October 29, 2006 13:58<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B>
[mapguide-users] perfomance test<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=656421321-29102006><FONT face=Arial size=2>Test case 1:
</FONT></SPAN><SPAN class=656421321-29102006><FONT face=Arial size=2>No geometry
filter, Fetch all attributes </FONT></SPAN></DIV>
<DIV><SPAN class=656421321-29102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656421321-29102006><FONT face=Arial
size=2>SDF 0.937 </FONT></SPAN></DIV>
<DIV><SPAN class=656421321-29102006>
<DIV><SPAN class=656421321-29102006><FONT face=Arial
size=2>SHP 8.531 </FONT></SPAN></DIV>
<DIV><SPAN class=656421321-29102006><FONT face=Arial
size=2>10GR2 18.172</FONT></SPAN></DIV>
<DIV><SPAN class=656421321-29102006><FONT face=Arial
size=2>XE
18.500</FONT></SPAN></DIV>
<DIV><SPAN class=656421321-29102006><SPAN class=656421321-29102006><SPAN
class=656421321-29102006><SPAN class=656421321-29102006><FONT face=Arial
size=2></FONT></SPAN> </DIV></SPAN></SPAN></SPAN></SPAN></DIV></BODY></HTML>