Re: [RADIATOR] AccountingTable Database Very big

2013-07-02 Thread sergio
Got it. Thank you > -Original Message- > From: a.l.m.bu...@lboro.ac.uk > Sent: Mon, 1 Jul 2013 19:11:51 +0100 > To: ri...@vianet.ca > Subject: Re: [RADIATOR] AccountingTable Database Very big > > Hi, > >> are you saying postgresql is really th

Re: [RADIATOR] AccountingTable Database Very big

2013-07-02 Thread sergio
I use mysql to be very fast, but as I am with a lot of data I was wondering if mysql will endure. > -Original Message- > From: ri...@vianet.ca > Sent: Mon, 01 Jul 2013 12:48:24 -0400 > To: a.l.m.bu...@lboro.ac.uk > Subject: Re: [RADIATOR] AccountingTable Database Very b

Re: [RADIATOR] AccountingTable Database Very big

2013-07-01 Thread A . L . M . Buxey
Hi, > are you saying postgresql is really that much better with regards to > performance, and worth switching to? really depends on what you are doing and how your database is structured. IMHO the answer is yes..(or even YES!) in many use cases. of course, you may get the speed benefits but its

Re: [RADIATOR] AccountingTable Database Very big

2013-07-01 Thread Michael
are you saying postgresql is really that much better with regards to performance, and worth switching to? On 01/07/13 03:29 AM, a.l.m.bu...@lboro.ac.uk wrote: > Hi, > >> I use mysql database and my AccountingTable has more than 40 million records >> per month. Does anyone here have any policy p

Re: [RADIATOR] AccountingTable Database Very big

2013-07-01 Thread sergio
OK, thanks for the help! > -Original Message- > From: ri...@vianet.ca > Sent: Sun, 30 Jun 2013 23:59:02 -0400 > To: ser...@inbox.com > Subject: Re: [RADIATOR] AccountingTable Database Very big > > i use mysql. no i don't have anything that reads the da

Re: [RADIATOR] AccountingTable Database Very big

2013-07-01 Thread sergio
0100 > To: ser...@inbox.com > Subject: Re: [RADIATOR] AccountingTable Database Very big > > Hi, > >> I use mysql database and my AccountingTable has more than 40 million >> records per month. Does anyone here have any policy purge? I have an >> extract of CGI a

Re: [RADIATOR] AccountingTable Database Very big

2013-07-01 Thread A . L . M . Buxey
Hi, > I use mysql database and my AccountingTable has more than 40 million records > per month. Does anyone here have any policy purge? I have an extract of CGI > access for my users and is very slow because the bank is getting too big. > Does anyone have any recommendation what I should do to

Re: [RADIATOR] AccountingTable Database Very big

2013-06-30 Thread Michael
tabase do you use? > > you have some script to extract such data in the Browser? > > Thanks > >> -Original Message- >> From: ri...@vianet.ca >> Sent: Sat, 29 Jun 2013 14:02:27 -0400 >> To: ser...@inbox.com >> Subject: Re: [RADIATOR] AccountingTa

Re: [RADIATOR] AccountingTable Database Very big

2013-06-30 Thread sergio
net.ca > Sent: Sat, 29 Jun 2013 14:02:27 -0400 > To: ser...@inbox.com > Subject: Re: [RADIATOR] AccountingTable Database Very big > > I use monthly tables. that really helped. Then use the year-month > attributes in your insert statements. And of course anything that reads >

Re: [RADIATOR] AccountingTable Database Very big

2013-06-29 Thread Michael
I use monthly tables. that really helped. Then use the year-month attributes in your insert statements. And of course anything that reads this data will have to be altered to support year-month tables. Also an external process that runs monthly to make sure that the tables get created ahead o