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: OC <email@hidden>
- Date: Sun, 10 Jul 2016 15:10:01 +0200
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