Alaska Software Inc. - Upsizing and indexes
Username: Password:
AuthorTopic: Upsizing and indexes
Roger DonnayUpsizing and indexes
on Tue, 09 Dec 2014 23:59:29 +0100
I used the DBFUPSIZE tool to import some databases into a PostGreSql table.

The data imported ok, but I have no indexes.

I can connect to the database with DacSession() and open the table with USE 
but I get none of my indexes.  What am I doing wrong?
Matej JuracRe: Upsizing and indexes
on Wed, 10 Dec 2014 11:27:56 +0100
Mr. Donnay , indexes@(%SQL) do not work that way. You design at database side
all indexes and constraints, and let database decide what it will use,
depending on use of ORDER BY, GROUP BY, WHERE in SELECT,UPDATE,etc criterias

I do not know particularities of Alaska conversion tool, but I believe you are
required to check tables and add apropriate indexes manually after import of
DBF's.

There is another post in this NG (few weeks back) that could shed some info on
it. Unfortunately, Alaska is not that open on documentation.

Roger Donnay wrote in message
news:c39ee41$2cfd1ca4$182201@news.alaska-software.com...
>I used the DBFUPSIZE tool to import some databases into a PostGreSql table.
>
>The data imported ok, but I have no indexes.
>
>I can connect to the database with DacSession() and open the table with USE 
>but I get none of my indexes.  What am I doing wrong?
Piotr DziurlaRe: Upsizing and indexes
on Wed, 10 Dec 2014 19:07:36 +0100
Roger,
you must define explicite index files in upsize file. Look at my upsize 
file.
Regards
Piotr


Uytkownik <Roger Donnay> napisa w wiadomoci 
news:c39ee41$2cfd1ca4$182201@news.alaska-software.com...
>I used the DBFUPSIZE tool to import some databases into a PostGreSql table.
>
> The data imported ok, but I have no indexes.
>
> I can connect to the database with DacSession() and open the table with 
> USE
> but I get none of my indexes.  What am I doing wrong? 




---
Ta wiadomosc e-mail jest wolna od wirusow i zlosliwego oprogramowania, poniewaz ochrona avast! Antivirus jest aktywna.
http://www.avast.com


pd_ezsv.upsize
Roger DonnayRe: Upsizing and indexes
on Fri, 12 Dec 2014 19:30:22 +0100
I have defined my indexes in the upsize tool.  I don't know why, but 
suddenly it started working.   The performance, however is unacceptable.
I'm going to stay with Advantage Server.


"Piotr Dziurla" <dpiotr@interia.pl> wrote in message 
news:7f29a703$5d286f8$1ad180@news.alaska-software.com...
>Roger,
>you must define explicite index files in upsize file. Look at my upsize 
>file.
>Regards
>Piotr
>
>
>Uytkownik <Roger Donnay> napisa w wiadomoci 
>news:c39ee41$2cfd1ca4$182201@news.alaska-software.com...
>>I used the DBFUPSIZE tool to import some databases into a PostGreSql 
table.
>>
>> The data imported ok, but I have no indexes.
>>
>> I can connect to the database with DacSession() and open the table with 
>> USE
>> but I get none of my indexes.  What am I doing wrong? 
>
>
>
>
>---
>Ta wiadomosc e-mail jest wolna od wirusow i zlosliwego oprogramowania, 
poniewaz ochrona avast! Antivirus jest aktywna.
>http://www.avast.com
>
Andreas HerdtRe: Upsizing and indexes
on Mon, 15 Dec 2014 11:21:24 +0100
Hi Roger,

Dietmar Schnitzer has posted his experience using the PGDBE. It is the
posting from 26.11.2014 in this newsgroup.

He also suffert from speed penalties and overcame the situation by
creating some SQL indexes on the ISAM indexes.

With my best regards,

  Andreas Herdt
  Alaska Software

--------------------------------------------------------------------

Technical Support:      support@alaska-software.com

News Server:            news.alaska-software.com
Homepage:               http://www.alaska-software.com
WebKnowledgeBase:       http://www.alaska-software.com/kbase.shtm

Fax European Office:    +49 (0) 61 96 - 77 99 99 23
Fax US Office:          +1 (646) 218 1281
--------------------------------------------------------------------

"Roger Donnay" wrote in message 
news:393f232b$784e9f9d$20188a@news.alaska-software.com...
>I have defined my indexes in the upsize tool.  I don't know why, but
> suddenly it started working.   The performance, however is unacceptable.
> I'm going to stay with Advantage Server.
>
>
> "Piotr Dziurla" <dpiotr@interia.pl> wrote in message
> news:7f29a703$5d286f8$1ad180@news.alaska-software.com...
>>Roger,
>>you must define explicite index files in upsize file. Look at my upsize
>>file.
>>Regards
>>Piotr
>>
>>
>>Uytkownik <Roger Donnay> napisa w wiadomoci
>>news:c39ee41$2cfd1ca4$182201@news.alaska-software.com...
>>>I used the DBFUPSIZE tool to import some databases into a PostGreSql
> table.
>>>
>>> The data imported ok, but I have no indexes.
>>>
>>> I can connect to the database with DacSession() and open the table with
>>> USE
>>> but I get none of my indexes.  What am I doing wrong?
>>
>>
>>
>>
>>---
>>Ta wiadomosc e-mail jest wolna od wirusow i zlosliwego oprogramowania,
> poniewaz ochrona avast! Antivirus jest aktywna.
>>http://www.avast.com
>>