Re: Splitting big database tables to speed up?
Re: Splitting big database tables to speed up?
- Subject: Re: Splitting big database tables to speed up?
- From: "Morris, Mark" <email@hidden>
- Date: Sun, 10 Jul 2016 16:31:07 +0000
- Thread-topic: Splitting big database tables to speed up?
I saw something, when I just did a quick search, called “zones” that have a “data” option, that on the surface sounds somewhat similar, but I’m not sure if they will have the same performance benefit that Oracle partitions produce.
Yes, we have tables that huge, and larger, so it makes a big difference to us. If you’re in this really huge situation as well, there are even more drastic measures possible. You could create separate physical databases, on multiple servers, and direct users upon login to instances that are pointing to the appropriate database. This would give significant performance gains, at the expense of significant increase in complexity.
Good luck!
Mark
> On Jul 10, 2016, at 10:34 AM, Samuel Pelletier <email@hidden> wrote:
>
> OC,
>
> To my knowledge, FrontBase does not support such thing. But I would not expect major speed gain unless your table have a very huge number of entries, in the 100s of millions.
>
> First make sure your indexes are kept in memory and uses READ_COMMITED.
>
> You may have to add or adjust some index to be 2 keys (partitioning attribute and searched attribute) to help the lookup. The partitioning described basically does that...
>
> If you have specific situation that takes unexpected time to execute, you may help by creating some multi key indices; querying multiple indexes and intersecting results is time consuming.
>
> Samuel
>
>
>> Le 10 juil. 2016 à 09:10, OC <email@hidden> a écrit :
>>
>> Mark,
>>
>> On 9. 7. 2016, at 22:54, "Morris, Mark" <email@hidden> wrote:
>>
>>> ... there might be support in your database for something that will get you the same results. We also have quite a few really huge tables, in Oracle, and we use table partitioning. You can partition on a value, and then all of the records in a partition are kept physically together and treated by the optimizer for all practical purposes like separate tables. Indexes can also be by partition, so the index search is limited as if it were a separate table as well. Huge performance gains for us.
>>
>> That would help tremendously. Is there anything similar in FrontBase?
>>
>> Thanks,
>> OC
>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden