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: Samuel Pelletier <email@hidden>
- Date: Sun, 10 Jul 2016 11:34:15 -0400
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