Cara, eu nao tenho muito o que comparar os dbs, porem eu uso tanto em casa (para aplicacoes caseiras) como no trabalho, linux/java/postgres
Nunca cheguei a usar um banco com mais de 5000 registros, mas acredito que o postgres suporta muito mais que isso pela velocidade que ele trata os 5000, se voce quiser mais informacoes sobre postgres e nao tiver problemas em ler em ingles entre em http://pgsql.dbexperts.com.br:8000/users-lounge/index.html (mirror brasileiro) ou va em www.postgres.org e procure por "User's Lounge" --- Estobel - Neimar Volpini <[EMAIL PROTECTED]> escreveu: > Segue um link e um material de pesquisa. > > http://www.dbexperts.com.br/documentos/comparativo > > Neimar > > ----- Original Message ----- > From: Alexey Honorio Rodrigues - PE > To: [EMAIL PROTECTED] > Sent: Friday, December 06, 2002 3:32 PM > Subject: [java-list] RES: PostGreSQL x outros bd's > e Java > > > Pessoal, > > Quem tiver experiencia, poderia fazer um > comparativo, mostrando os pontos fortes x pontos > fracos, do PostGreSQL x Sql-Server ou MySql ou > Oracle? > Estou pensando em migrar minhas aplicações de > SQL-Server para PostGreSQL, pelo que falam, e com > isso, ficar totalmente no mundo "open source", com > Java/PostGreSQL/Linux!!! Que sonho! > Mas minhas aplicações sao bem pesadas (os bancos > chegam a ter tabelas com 15 milhoes de > registros...). > Gostaria de materiais a respeito do PostGre, > tutoriais, links...dicas, comentários...qualquer > coisa que me ajude, "free my mind"... > > Agradeço desde já. > > Sds, > > Alexey > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system > (http://www.grisoft.com). > Version: 6.0.426 / Virus Database: 239 - Release > Date: 02/12/2002 > > <HR> <!-- saved from url=(0022)http://internet.e-mail --> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><html><head> <meta http-equiv="CONTENT-TYPE" content="text/html; charset=iso-8859-1"><title></title> <meta name="GENERATOR" content="OpenOffice.org 1.0.1 (Linux)"> <meta name="AUTHOR" content="Neimar Volpini Neimar"> <meta name="CREATED" content="20021209;18404400"> <meta name="CHANGED" content="16010101;0"> <style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Albany"; font-size:x-small } --> </style></head> <body text="#000000"> <table frame="box" cellspacing="0" cols="4" rules="groups" border="1"> <colgroup><col width="364"></colgroup> <colgroup><col width="233"></colgroup> <colgroup><col width="198"></colgroup> <colgroup><col width="157"></colgroup> <tbody> <tr> <td width="364" height="20" align="left" valign="middle" bgcolor="#333333"><font face="Arial" size="3" color="#ffffff">Caracteristicas</font></td> <td width="233" height="20" align="center" valign="middle" bgcolor="#333333"><font face="Arial" size="3" color="#ffffff">MySQL versão 3</font></td> <td width="198" height="20" align="center" valign="middle" bgcolor="#333333"><font face="Arial" size="3" color="#ffffff">PostreSQL</font></td> <td width="157" height="20" align="center" valign="middle" bgcolor="#333333"><font face="Arial" size="3" color="#ffffff">Oracle</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Arquitetura</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">Threads</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">Processos</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">Processos e threads</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Controle de Acesso / Grants / Criptografia</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Comandos SQL básicos</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Funções agregadas</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Subqueries</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Outer joins</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">Sintaxe não-padrão</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Funções estatisticas</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Views</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Transações ( Commit e Rollback)</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">Opcional (mysqld-max)</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Two-Phase-Commit (bancos distribuidos)</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Níveis de Isolamento</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Extensões Objeto-relacionais</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">BLOBs (dados binários)</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Funções definidas pelo usuário</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Procedimentos armazenados</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">Não retorna cursores</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Triggers</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Integridade Referencial</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">Não verificada em atualizações</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Replicação</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3">Com software de terceiros</font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">Com software de terceiros</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Views Materializadas</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3">X</font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Índices de bitmap</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> <tbody> <tr> <td width="364" height="20" align="left"><font face="Arial" size="3">Otimizações para star schemes (data warehouse)</font></td> <td width="233" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="198" height="20" align="center"><font face="Arial" size="3"><br></font></td> <td width="157" height="20" align="center"><font face="Arial" size="3">X</font></td> </tr> </tbody> </table> <!-- ************************************************************************** --> <br> </body></html> > ------------------------------ LISTA SOUJAVA > ---------------------------- > http://www.soujava.org.br - Sociedade de Usuários > Java da Sucesu-SP > dúvidas mais comuns: > http://www.soujava.org.br/faq.htm > regras da lista: > http://www.soujava.org.br/regras.htm > historico: > http://www.mail-archive.com/java-list%40soujava.org.br > para sair da lista: envie email para > [EMAIL PROTECTED] > ------------------------------------------------------------------------- ===== -------------------------------------------------- Alan Moraes Souza -> Programador Java da Ag5 Tecnologia -> Bacharelando em Ciência da Computação na UFBA _______________________________________________________________________ Busca Yahoo! O melhor lugar para encontrar tudo o que você procura na Internet http://br.busca.yahoo.com/ ------------------------------ LISTA SOUJAVA ---------------------------- http://www.soujava.org.br - Sociedade de Usuários Java da Sucesu-SP dúvidas mais comuns: http://www.soujava.org.br/faq.htm regras da lista: http://www.soujava.org.br/regras.htm historico: http://www.mail-archive.com/java-list%40soujava.org.br para sair da lista: envie email para [EMAIL PROTECTED] -------------------------------------------------------------------------
