Re: [PERFORM] hardware advice

2012-09-28 Thread M. D.
On 09/28/2012 09:57 AM, David Boreham wrote: On 9/28/2012 9:46 AM, Craig James wrote: Your best warranty would be to have the confidence to do your own repairs, and to have the parts on hand. I'd seriously consider putting your own system together. Maybe go to a few sites with pre-configured m

Re: [PERFORM] hardware advice

2012-09-27 Thread M. D.
On 09/27/2012 02:55 PM, Scott Marlowe wrote: On Thu, Sep 27, 2012 at 2:46 PM, M. D. wrote: select item.item_id,item_plu.number,item.description, (select number from account where asset_acct = account_id), (select number from account where expense_acct = account_id), (select number from account

Re: [PERFORM] hardware advice

2012-09-27 Thread M. D.
On 09/27/2012 01:37 PM, Craig James wrote: I don't think you've supplied enough information for anyone to give you a meaningful answer. What's your current configuration? Are you I/O bound, CPU bound, memory limited, or some other problem? You need to do a specific analysis of the queries that

Re: [PERFORM] hardware advice

2012-09-27 Thread M. D.
On 09/27/2012 01:47 PM, David Boreham wrote: On 9/27/2012 1:37 PM, Craig James wrote: We use a "white box" vendor (ASA Computers), and have been very happy with the results. They build exactly what I ask for and deliver it in about a week. They offer on-site service and warranties, but don't p

Re: [PERFORM] hardware advice

2012-09-27 Thread M. D.
On 09/27/2012 01:22 PM, Claudio Freire wrote: On Thu, Sep 27, 2012 at 4:11 PM, M. D. wrote: At this point I'm dealing with a fairly small database of 8 to 9 GB. ... The on_hand lookup table currently has 3 million rows after 4 years of data. ... For both servers I'd have at leas

[PERFORM] hardware advice

2012-09-27 Thread M. D.
Hi everyone, I want to buy a new server, and am contemplating a Dell R710 or the newer R720. The R710 has the x5600 series CPU, while the R720 has the newer E5-2600 series CPU. At this point I'm dealing with a fairly small database of 8 to 9 GB. The server will be dedicated to Postgres and

Re: [PERFORM] slow query on tables with new columns added.

2011-09-26 Thread M. D.
it and return 0 for both columns on that customer_id as it should always be 0. On 09/24/2011 12:10 AM, Filip RembiaƂkowski wrote: 2011/9/23 M. D. <li...@turnkey.bz> I did a software upgrade, and with it came a new feature where

[PERFORM] slow query on tables with new columns added.

2011-09-23 Thread M. D.
Hi everyone, I did a software upgrade, and with it came a new feature where when selecting a customer it queries for the sum of a few columns. This takes 7 seconds for the 'Cash Sale' customer - by far the most active customer. I'd like to see if it's possible to get it down a bit by changin

Re: [PERFORM] cpu comparison

2011-07-18 Thread M. D.
On 07/18/2011 03:56 PM, Tomas Vondra wrote: Dne 18.7.2011 22:11,k...@rice.edu napsal(a): In my testing I have a 32bit CentOS on the x3450, but a 64bit CentOS on the E5335. Can this make such a bit difference or should the perform fairly close to the same speed? Both servers have 8GB of RAM, a

[PERFORM] cpu comparison

2011-07-18 Thread M. D.
I have 2 small servers, one a fairly new server with a x3450 (4-core with HT) cpu running at 2.67GHz and an older E5335 (4-core) cpu running at 2GHz. I have been quite surprised how the E5335 compares very closely to the x3450, but maybe I have tested it wrongly. here's the CPUINFO: processo