Re: Advices for work with big tables

2014-05-16 Thread shawn l.green
Hello Antonio, On 5/16/2014 9:49 AM, Antonio Fernández Pérez wrote: Hi, I write to the list because I need your advices. I'm working with a database with some tables that have a lot of rows, for example I have a table with 8GB of data. How you design your tables can have a huge impact on pe

Re: Advices for work with big tables

2014-05-16 Thread Johan De Meersman
- Original Message - > From: "Antonio Fernández Pérez" > Subject: Advices for work with big tables > > Hi, > > I write to the list because I need your advices. > > I'm working with a database with some tables that have a lot of rows, for > example I have a table with 8GB of data. > > H

Re: Advices for work with big tables

2014-05-16 Thread Reindl Harald
Am 16.05.2014 15:49, schrieb Antonio Fernández Pérez: > I write to the list because I need your advices. > > I'm working with a database with some tables that have a lot of rows, for > example I have a table with 8GB of data. > > How can I do to have a fluid job with this table? > > My server w

Advices for work with big tables

2014-05-16 Thread Antonio Fernández Pérez
Hi, I write to the list because I need your advices. I'm working with a database with some tables that have a lot of rows, for example I have a table with 8GB of data. How can I do to have a fluid job with this table? My server works with disk cabin and I think that sharding and partitioning ar