Re: What's a reasonable maximum number for table partitions?

Ah, I should have thought that it would be simple. Thanks a lot Vick.

Regards
Seref

On Fri, Feb 13, 2015 at 4:54 PM, Vick Khera <vivek(at)khera(dot)org> wrote:

> On Fri, Feb 13, 2015 at 11:29 AM, Seref Arikan <
> serefarikan(at)kurumsalteknoloji(dot)com> wrote:
>
>> Hi Bill,
>> Could you point at some resource(s) that discuss inserting directly into
>> the partition? Would it be possible to read directly from the partition as
>> well?
>>
>> When preparing your SQL statement, you just specify the partition
> directly like this. Here's a snippet from my code in perl.
>
> my $msg_recipients_modulo = 100; # number of partitions
>
> sub msg_recipients_part($) {
> use integer;
> my $id = shift;
> my $part = $id % $msg_recipients_modulo;
> return 'msg_recipients_' . sprintf('%02d',$part);
> }
>
> then in when generating sql you do
>
> $table = msg_recipients_part($msg_id);
> $sql = "SELECT FROM $table WHERE ..."
>
> or something similar for insert/update.
>
>
>