<!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=643371717-22112006><FONT face=Arial
color=#0000ff size=2>Mr Jackie,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>My advice is (and a bit the same as
Pedro):</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>If you are not very experienced but there is (lot of) money
in the project:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>don't hesitate and go for ORACLE /
SPATIAL.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>I offeres a very extended, stable, framework with zillion
of features.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>Furthermore, they offer a very quick and elaborate support
system.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>To conclude: VERY proffessional, but RATHER
expensive.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>If you wanna go for the 'cheap' version. Then Postgis is a
choice. It still has a rather fast update-cycle (this means it is not that
stable yet).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>But that is logic: it is open source.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>Also support......... by the people like this little
mailing list.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>So not that professional, and above all (like Pedro
indicated too): most of the solutions you have to devine yourself and ask
simple/small questions to mailing list.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>ArcView: same story: commercial, professional and
licenced</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>Choice between Oracle or Arcview ? I don't know. First, I
only worked with Oracle/Spatial and that rockes as hell. Second, it depends on
the budget and other factors like:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>- dimension (DB/DB-cluster ; mono-processors
/multi-processors) (Oracle for example is licenced by CPU)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>- response time</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2>- ..........</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=643371717-22112006></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>zhang
Jackie<BR><B>Sent:</B> mercredi 22 novembre 2006 03:57<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] build a SDB cache for
Spatial Database basedonpostgis and postgresql<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Mr.<SPAN id=_user_pdoria@netmadeira.com>Pedro </SPAN></DIV>
<DIV><SPAN></SPAN> your advice is very important for me an thank you
very much for this.</DIV>
<DIV><BR> can you tell me how to profile the performance of
PostGreSQL?</DIV>
<DIV>you say "<SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Solutions are as good
as the one who develops them</SPAN>" Do you mean that my cooperative cache idea
can not achieve expected performance? and so this is a not a good idea?
<BR> </DIV>
<DIV><SPAN class=gmail_quote>2006/11/22, Pedro Doria Meunier <<A
href="mailto:pdoria@netmadeira.com">pdoria@netmadeira.com</A>>:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV lang=PT link="blue" vlink="purple">
<DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Mr
Jackie,</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">It's obvious you're
pulling out straws since it's apparent that you don't have a clue how to even
benchmark Postgresql. </SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Solutions are as good
as the one who develops them.</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">My best advice to you
is that, beyond asking for free papers/experience, you should first take the
time to experiment/study Posgresql and specifically PostGIS extensions, know
how to benchmark your own implementations and then compare the same line of
though with other products. </SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Speaking strictly for
myself, my company uses PG/PostGIS *<B><SPAN
style="FONT-WEIGHT: bold">extensively </SPAN></B>* with tables spanning
millions of records and we still tip the hat to the PG/PostGIS
developers.</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Robustness is a given
as well as scalability and stability. In short, PG/PostGIS
rocks!</SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Building a SDB is
more complex than you can now imagine and it's a multidisciplinary task.
</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Tip: start with
asking small questions (reflecting your commitment/investment to PG/PostGIS).
This group is a very friendly bunch (and helpful) when someone asks
specific/informed questions. </SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P><FONT face=Arial color=navy size=2><SPAN lang=EN-GB
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Sincerely,</SPAN></FONT></P>
<DIV>
<P><U><FONT face="Bauhaus 93" color=#0080c0 size=5><SPAN
style="FONT-SIZE: 18pt; COLOR: #0080c0">Pedro Doria
Meunier</SPAN></FONT></U><FONT color=navy><SPAN
style="COLOR: navy"></SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">(351) 91 302 49 72 -
(351) 96 247 99 12</SPAN></FONT><FONT color=navy><SPAN
style="COLOR: navy"></SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">MSN - <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:pdoriam@hotmail.com"
target=_blank>pdoriam@hotmail.com</A></SPAN></FONT><FONT color=navy><SPAN
style="COLOR: navy"></SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">ICQ -
308-182-126</SPAN></FONT></P>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Skype:
pdoriam</SPAN></FONT><FONT color=navy><SPAN
style="COLOR: navy"></SPAN></FONT></P></DIV>
<P><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users-bounces@postgis.refractions.net"
target=_blank>postgis-users-bounces@postgis.refractions.net</A> [mailto:<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users-bounces@postgis.refractions.net" target=_blank>
postgis-users-bounces@postgis.refractions.net</A>] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>zhang Jackie<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> quarta-feira, 22 de Novembro de
2006 1:32<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> <A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users@postgis.refractions.net"
target=_blank>postgis-users@postgis.refractions.net</A><BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [postgis-users] build a SDB
cache for Spatial Database based onpostgis and postgresql</SPAN></FONT><SPAN
lang=EN-US></SPAN></P></DIV>
<DIV><SPAN class=e id=q_10f0d685d7c5ff33_1>
<P><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P><FONT face=Verdana size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana"> I am
interesting in PostGis and want to do something on it. My idea is to build a
Spatial Database Cache to accelerate GIS applications .So I want to ask you
some question and hope to get your answer. </SPAN></FONT></P>
<DIV>
<P><FONT face=Verdana size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana"> 1. As we all
know, PostGis is a Spatial extention for PostGreSQL. And there are also some
other products such as ArcSDE, Oracle Spatial .Have you ever do some
performance comparison between them.If you have ever done such work,Could you
give me some information on it. If not, is it because that you team did not
care about performance and just concerned with correctness of the program. And
if you can give me some materials on performance comparison on such Spatial
Database extention including ArcSDE, Oracle Spatial ,MySQL ,etc.
</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=Verdana size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana"> 2. Since
Google Earth is lauched ,Many GIS systems are used by more and more
people,so the important features of Software becomes more and more
important,such as sacalibity, robust, stability,etc. Can you give me some
information and papers on the bottleneck of these applications.Especially, are
computing and I/O requirements very important and become bottlenecks,Of
course, If you know some related solutions , you can mail
me.</SPAN></FONT></P></DIV>
<DIV>
<P><FONT face=Verdana size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana"> I have
searche lots of papers and get an overview of it. But I felt I did not
figure out the truth. So I want to get some more accurate information
on this field.
</SPAN></FONT></P></DIV></SPAN></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
onclick="return top.js.OpenExtLink(window,event,this)"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users
</A><BR><BR><BR></BLOCKQUOTE></DIV><BR></BODY></HTML>