no there is no index building or alter doing on.
On 6/13/08, mos <[EMAIL PROTECTED]> wrote:
>
> At 11:38 AM 6/12/2008, you wrote:
>
>> Hi Sebastian,
>>
>> I tried to order the column as close as possible to the table structure
>> and
>> removed all the formatn command and if conditions, but still
At 11:38 AM 6/12/2008, you wrote:
Hi Sebastian,
I tried to order the column as close as possible to the table structure and
removed all the formatn command and if conditions, but still it take 3 min
Are you sure when you are running the fulltext search, the table isn't
locked because you are
Hi Sebastian,
I tried to order the column as close as possible to the table structure and
removed all the formatn command and if conditions, but still it take 3 min
select
ITEM_ID,ITEM_TITL,AUCT_START_DATE,AUCT_END_DATE,AUCT_DURTN_DAYS,AUCT_TYPE_CODE,LEAF_CATEG_ID,SLR_ID,START_PRICE_USD,RSRV_PR
On 6/12/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
>
>
> On 6/12/08, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
>>
>> Ananda Kumar schrieb:
>>
>>> Hi All,
>>> We have table with 99 Million records, with fulltext index.
>>> But when there is not load the sql's performance in just 6 sec, but when
On 6/12/08, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
>
> Ananda Kumar schrieb:
>
>> Hi All,
>> We have table with 99 Million records, with fulltext index.
>> But when there is not load the sql's performance in just 6 sec, but when
>> anyother jobs like Index creation or data load is happening it
Ananda Kumar schrieb:
Hi All,
We have table with 99 Million records, with fulltext index.
But when there is not load the sql's performance in just 6 sec, but when
anyother jobs like Index creation or data load is happening its take close
to 3 min for the same query to execute, any ways to improve
Hi All,
We have table with 99 Million records, with fulltext index.
But when there is not load the sql's performance in just 6 sec, but when
anyother jobs like Index creation or data load is happening its take close
to 3 min for the same query to execute, any ways to improve the performance
of this
