[GENERAL] Greetings, Thinking about converting

2001-06-10 Thread Miguel Angel Heredia
Hi, I have a database with the 2 principal tables using 716,819 rows and 43,157,442 rows each one, related each one, I have some triggers and stored procedures and views having a frontend made in Visual Basic using ODBC and ADO to connect to the database, Im considering to move from

Re: [GENERAL] Greetings, Thinking about converting

2001-06-10 Thread GH
On Sun, Jun 10, 2001 at 06:32:58PM -0600, some SMTP stream spewed forth: Hi, I have a database with the 2 principal tables using 716,819 rows and 43,157,442 rows each one, related each one, I have some triggers and stored procedures and views having a frontend made in Visual Basic using ODBC

Re: [GENERAL] Greetings, Thinking about converting

2001-06-10 Thread GH
On Sun, Jun 10, 2001 at 07:31:10PM -0600, some SMTP stream spewed forth: I suggest you check out FreeBSD: www.freebsd.org. If you have no experience with either FreeBSD or some Linux variant, I would say switch to FreeBSD, otherwise use whatever you are comfortable with other than

Re: [GENERAL] Greetings, Thinking about converting

2001-06-10 Thread Miguel Angel Heredia
, Thinking about converting On Sun, Jun 10, 2001 at 07:31:10PM -0600, some SMTP stream spewed forth: I suggest you check out FreeBSD: www.freebsd.org. If you have no experience with either FreeBSD or some Linux variant, I would say switch to FreeBSD, otherwise use whatever you

Re: [GENERAL] Greetings, Thinking about converting

2001-06-10 Thread GH
Opinion that you dont share as I see.. but, OS and hardware appart, what about the MSSQL vs MySQL vs PostgreSQL discussion. what you think ? General consensus is that MySQL is the fastest for simple selects. If you have a decent number of (more than 2 or 3) concurrent users, PostgreSQL will