message I consider that message to
be my property and I will copy, share and deceminate as I see fit. I will
provide attribution when appropriate and I willl endeavour to comply with all
reasonable requests. However, I reject all threats or implied threats of legal
action arising from an error or mistake on your part. It is your responsibility
to manage your communications appropriately, not mine.
--
Tim Cross
ight be the only way to get the performance you want. The big positive
to a re-implementation is that you usually get a better solution because
you are implementing with more knowledge and experience about the
problem domain. Design is often cleaner and as a result, easier to
maintain. It usually takes a lot less time than the original
implementation as well and can be the more economical solution compared
to fighting a system which has fundamental design limitations that
restrict performance.
good luck,
Tim
--
Tim Cross
time
consuming. Highly recommend PostgreSQL: High Performance (Ahmed & SMith)
and Mastering Postgres (Shonig) for valuable background/tips - there
really is just far too much to communicate effectively via email.
Tim
--
Tim Cross
depend on what the
memory and cpu profile of the system is. More memory, less use of temp
files, faster system, so spend a bit of time to make sure your system is
configured to squeeze as much out of that RAM as you can!
--
Tim Cross
mbers (millions) of rows into a postgres
database from a Javascript application and found using the COPY command
was much, much faster than doing regular inserts (even with multi-insert
commit). If you can do this using the driver you are using, that will
give you the largest performance boost.
--
Tim Cross
