I spent a great deal of time over
the past week looking seriously at Postgres and MYSQL.
Objectively I am not seeing that
much of an improvement in speed with MYSQL, and we have a huge investment in
postgrs.
So I am planning on sticking with
postgres fro our production database (going live this
weekend).
Many people have offered a great
deal of help and I appreciate all that time and energy.
I did not find any resolutions to
my issues with Commandprompt.com (we only worked together 2.5
hours).
Most of my application is working
about the same speed as MSSQL server (unfortunately its twice the speed box,
but as many have pointed out it could be an issue with the 4 proc dell). I
spent considerable time with Dell and could see my drives are delivering 40
meg per sec.
Things I still have to make better
are my settings in config, I have it set to no merge joins and no seq
scans.
I am going to have to use
flattened history files for reporting (I saw huge difference here the view for
audit cube took 10 minutes in explain analyze and the flattened file took
under one second).
I understand both of these
practices are not desirable, but I am at a place where I have to get it live
and these are items I could not resolve.
I may try some more time with
Commanpromt.com, or seek other professional help.
In stress testing I found Postgres
was holding up very well (but my IIS servers could not handle much of a load
to really push the server).
I have a few desktops acting as
IIS servers at the moment and if I pushed past 50 consecutive users it pretty
much blew the server up.
On inserts that number was like 7
consecutive users and updates was also like 7 users.
I believe that was totally IIS not
postgres, but I am curious as to if using postgres odbc will put more stress
on the IIS side then MSSQL did.
I did have a question if any folks
are using two servers one for reporting and one for data entry what system
should be the beefier?
I have a 2proc machine I will be
using and I can either put Sears off by themselves on this machine or split up
functionality and have one for reporting and one for inserts and updates; so
not sure which machine would be best for which spot (reminder the more robust
is a 4proc with 8 gigs and 2 proc is 4 gigs, both dells).
Thank you for any ideas in this
arena.
Joel Fradkin
You didnt tell us what
OS are you using, windows?
If you want good
performance you must install unix on that
machine,
---