Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

CacheOpenTables

7 posts in Clipper Last posting was on 2009-04-16 17:44:18.0Z
Jan Sperling Posted on 2009-04-15 17:44:20.0Z
Reply-To: "Jan Sperling" <sperling@racsa.co.cr>
From: "Jan Sperling" <sperling@racsa.co.cr>
Newsgroups: advantage.clipper
Subject: CacheOpenTables
Date: Wed, 15 Apr 2009 09:44:20 -0800
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 190.10.50.124
Message-ID: <49e600b1@solutions.advantagedatabase.com>
X-Trace: 15 Apr 2009 09:43:45 -0700, 190.10.50.124
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!190.10.50.124
Xref: solutions.advantagedatabase.com Advantage.Clipper:4398
Article PK: 1107069

Hi all:

Some time ago, I asked if the AdsCacheOpenTables function is included in the
RDD, and I was told it's not.

However, my question is:

If I have a 16-bit app with Clip4Win, can I access the ACE32.DLL and run the
AdsCacheOpenTables function?
I have already written the access to the DLL, I load the library, and with
GetProcAddress I can actually run the function.
However, the function always return 0.

Could this way work, or there is no way at all to use this function in an
16bit environment?

TIA,

__________________________________
Jan Sperling Frischmuth
Presidente,
Sperling Consultoría Informática S.A.

Tels:
(506)2225-9667, (506)2225-9219
(506)2253-2460, (506)2253-2473
(506)2280-6232, (506)2281-3739
Fax: (506)2281-3739
Cel: (506)8381-1488
email: jan.sperling@grecoavalon.com
web: www.grecoavalon.com

Este correo electrónico contiene información confidencial. En caso de que
usted no sea el receptor previsto, contáctenos al teléfono (506)2225-9667 o
por correo electrónico y elimine inmediatamente el mensaje.
This e-mail contain confidential information. If you are not the intended
recipient, please notify us by reply e-mail, or by telephone at
(506)2225-9667, and destroy the original message immediately.


Mark Wilkins Posted on 2009-04-15 16:25:54.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.clipper
References: <49e600b1@solutions.advantagedatabase.com>
Subject: Re: CacheOpenTables
Date: Wed, 15 Apr 2009 10:25:54 -0600
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <49e60a6a@solutions.advantagedatabase.com>
X-Trace: 15 Apr 2009 10:25:14 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Clipper:4399
Article PK: 1107067

Hi Jan,

I do not think that will work. The call is probably succeeding (a return
code of 0 means success). But I believe that Clip4Win is using a 16-bit
client. The open table caching is all client-side, so a call into a 32-bit
client will not affect the usage in a 16-bit client DLL.

Mark Wilkins
Advantage R&D

"Jan Sperling" <sperling@racsa.co.cr> wrote in message
news:49e600b1@solutions.advantagedatabase.com...
> Hi all:
>
> Some time ago, I asked if the AdsCacheOpenTables function is included in
> the RDD, and I was told it's not.
>
> However, my question is:
>
> If I have a 16-bit app with Clip4Win, can I access the ACE32.DLL and run
> the AdsCacheOpenTables function?
> I have already written the access to the DLL, I load the library, and with
> GetProcAddress I can actually run the function.
> However, the function always return 0.
>
> Could this way work, or there is no way at all to use this function in an
> 16bit environment?
>
> TIA,
>
> __________________________________
> Jan Sperling Frischmuth
> Presidente,
> Sperling Consultoría Informática S.A.
>
> Tels:
> (506)2225-9667, (506)2225-9219
> (506)2253-2460, (506)2253-2473
> (506)2280-6232, (506)2281-3739
> Fax: (506)2281-3739
> Cel: (506)8381-1488
> email: jan.sperling@grecoavalon.com
> web: www.grecoavalon.com
>
> Este correo electrónico contiene información confidencial. En caso de que
> usted no sea el receptor previsto, contáctenos al teléfono (506)2225-9667
> o por correo electrónico y elimine inmediatamente el mensaje.
> This e-mail contain confidential information. If you are not the intended
> recipient, please notify us by reply e-mail, or by telephone at
> (506)2225-9667, and destroy the original message immediately.
>
>


Jan Sperling Posted on 2009-04-15 20:32:32.0Z
Reply-To: "Jan Sperling" <sperling@racsa.co.cr>
From: "Jan Sperling" <sperling@racsa.co.cr>
Newsgroups: advantage.clipper
References: <49e600b1@solutions.advantagedatabase.com> <49e60a6a@solutions.advantagedatabase.com>
Subject: Re: CacheOpenTables
Date: Wed, 15 Apr 2009 12:32:32 -0800
Lines: 93
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 190.10.50.124
Message-ID: <49e62817@solutions.advantagedatabase.com>
X-Trace: 15 Apr 2009 12:31:51 -0700, 190.10.50.124
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!190.10.50.124
Xref: solutions.advantagedatabase.com Advantage.Clipper:4400
Article PK: 1107071

Hi Mark:

Hmm, it was worth ty try... :-)

Any chance to get this incorporated into the 16bit dll?

We have a big app, which in certain classes opens up to 160 tables
simultaneously. We have tried with a 32bit beta version of our app, and we
were able to run successfully the CacheOpenTables function with great
performance improvement.

Just asking... :-)

Thanks Mark
__________________________________
Jan Sperling Frischmuth
Presidente,
Sperling Consultoría Informática S.A.

Tels:
(506)2225-9667, (506)2225-9219
(506)2253-2460, (506)2253-2473
(506)2280-6232, (506)2281-3739
Fax: (506)2281-3739
Cel: (506)8381-1488
email: jan.sperling@grecoavalon.com
web: www.grecoavalon.com

Este correo electrónico contiene información confidencial. En caso de que
usted no sea el receptor previsto, contáctenos al teléfono (506)2225-9667 o
por correo electrónico y elimine inmediatamente el mensaje.
This e-mail contain confidential information. If you are not the intended
recipient, please notify us by reply e-mail, or by telephone at
(506)2225-9667, and destroy the original message immediately.

"Mark Wilkins" <mark@no.email> escribió en el mensaje
news:49e60a6a@solutions.advantagedatabase.com...

> Hi Jan,
>
> I do not think that will work. The call is probably succeeding (a return
> code of 0 means success). But I believe that Clip4Win is using a 16-bit
> client. The open table caching is all client-side, so a call into a
> 32-bit client will not affect the usage in a 16-bit client DLL.
>
> Mark Wilkins
> Advantage R&D
>
> "Jan Sperling" <sperling@racsa.co.cr> wrote in message
> news:49e600b1@solutions.advantagedatabase.com...
>> Hi all:
>>
>> Some time ago, I asked if the AdsCacheOpenTables function is included in
>> the RDD, and I was told it's not.
>>
>> However, my question is:
>>
>> If I have a 16-bit app with Clip4Win, can I access the ACE32.DLL and run
>> the AdsCacheOpenTables function?
>> I have already written the access to the DLL, I load the library, and
>> with GetProcAddress I can actually run the function.
>> However, the function always return 0.
>>
>> Could this way work, or there is no way at all to use this function in an
>> 16bit environment?
>>
>> TIA,
>>
>> __________________________________
>> Jan Sperling Frischmuth
>> Presidente,
>> Sperling Consultoría Informática S.A.
>>
>> Tels:
>> (506)2225-9667, (506)2225-9219
>> (506)2253-2460, (506)2253-2473
>> (506)2280-6232, (506)2281-3739
>> Fax: (506)2281-3739
>> Cel: (506)8381-1488
>> email: jan.sperling@grecoavalon.com
>> web: www.grecoavalon.com
>>
>> Este correo electrónico contiene información confidencial. En caso de que
>> usted no sea el receptor previsto, contáctenos al teléfono (506)2225-9667
>> o por correo electrónico y elimine inmediatamente el mensaje.
>> This e-mail contain confidential information. If you are not the intended
>> recipient, please notify us by reply e-mail, or by telephone at
>> (506)2225-9667, and destroy the original message immediately.
>>
>>
>
>


Mark Wilkins Posted on 2009-04-15 23:21:21.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.clipper
References: <49e600b1@solutions.advantagedatabase.com> <49e60a6a@solutions.advantagedatabase.com> <49e62817@solutions.advantagedatabase.com>
Subject: Re: CacheOpenTables
Date: Wed, 15 Apr 2009 17:21:21 -0600
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <49e66bca@solutions.advantagedatabase.com>
X-Trace: 15 Apr 2009 17:20:42 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Clipper:4401
Article PK: 1107070


"Jan Sperling" <sperling@racsa.co.cr> wrote in message
news:49e62817@solutions.advantagedatabase.com...
> Hi Mark:
>
> Hmm, it was worth ty try... :-)

It was a good idea on your part. It would have worked if it was all
server-side functionality. But, but it's nature, that functionality is
largely a client-side feature.

>
> Any chance to get this incorporated into the 16bit dll?

It does not seem very likely to me. It's been quite some time since I dealt
with that product ... in fact I'm rather quite hazy on the architecture. If
I remember correctly, Clip4Win apps link to the 16-bit DOS libraries (the
same as the Clipper RDD). I don't think we have plans to update that code
with "open file" caching. The RDD code is substantially different than the
32-bit code, so it would not be simple to port the table caching logic. It
would be a rewrite.

>
> We have a big app, which in certain classes opens up to 160 tables
> simultaneously. We have tried with a 32bit beta version of our app, and
> we were able to run successfully the CacheOpenTables function with great
> performance improvement.

I can see why that would help you especially if there are very many indexes.
Opening a lot of tables repeatedly can involve quite a few round trips to
the server. Is there any way you could implement a simple form of the
caching in your own application? I realize that it is quite a different
task at the application level unless all table opens and closes are done
through one single piece of code. On the other hand, it could probably be
done "better" in the application because it could be tailored to meet the
exact needs.

>
> Just asking... :-)

No problem ... I would have asked too. :)

Mark Wilkins
Advantage R&D


Jan Sperling Posted on 2009-04-16 16:04:28.0Z
Reply-To: "Jan Sperling" <sperling@racsa.co.cr>
From: "Jan Sperling" <sperling@racsa.co.cr>
Newsgroups: advantage.clipper
References: <49e600b1@solutions.advantagedatabase.com> <49e60a6a@solutions.advantagedatabase.com> <49e62817@solutions.advantagedatabase.com> <49e66bca@solutions.advantagedatabase.com>
Subject: Re: CacheOpenTables
Date: Thu, 16 Apr 2009 08:04:28 -0800
Lines: 101
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 190.10.50.124
Message-ID: <49e73aca@solutions.advantagedatabase.com>
X-Trace: 16 Apr 2009 08:03:54 -0700, 190.10.50.124
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!190.10.50.124
Xref: solutions.advantagedatabase.com Advantage.Clipper:4402
Article PK: 1107073

Hi Mark:

Well, we have all open/close/locking in 1 single code, and we have already
written the caching code.
But there´s a difference between having tables left open at the client side
and to deal with it, or leaving this task to the server.

Just a final question:

Having in mind I could take the ACE32.DLL, and write my own PROCADDRESS
code, so I could use any function of it:

In the 16bit case, I have to use the following code to use ADS as default:

REQUEST DBFCDXAX
AX_SetRDD("DBFCDXAX")

In xHarbour case:

REQUEST ADS
AdsSetFileType(2)
RDDRegister( "ADS", 1 )
AdsRightsCheck(0)
AdsCacheOpenTables(200)

I´m pretty sure you will tell me this isn't going to work, but:
With only having access to ACE32, is there a way to get it to work
transparently?


TIA
__________________________________
Jan Sperling Frischmuth
Presidente,
Sperling Consultoría Informática S.A.

Tels:
(506)2225-9667, (506)2225-9219
(506)2253-2460, (506)2253-2473
(506)2280-6232, (506)2281-3739
Fax: (506)2281-3739
Cel: (506)8381-1488
email: jan.sperling@grecoavalon.com
web: www.grecoavalon.com

Este correo electrónico contiene información confidencial. En caso de que
usted no sea el receptor previsto, contáctenos al teléfono (506)2225-9667 o
por correo electrónico y elimine inmediatamente el mensaje.
This e-mail contain confidential information. If you are not the intended
recipient, please notify us by reply e-mail, or by telephone at
(506)2225-9667, and destroy the original message immediately.

"Mark Wilkins" <mark@no.email> escribió en el mensaje
news:49e66bca@solutions.advantagedatabase.com...

>
> "Jan Sperling" <sperling@racsa.co.cr> wrote in message
> news:49e62817@solutions.advantagedatabase.com...
>> Hi Mark:
>>
>> Hmm, it was worth ty try... :-)
>
> It was a good idea on your part. It would have worked if it was all
> server-side functionality. But, but it's nature, that functionality is
> largely a client-side feature.
>
>>
>> Any chance to get this incorporated into the 16bit dll?
>
> It does not seem very likely to me. It's been quite some time since I
> dealt with that product ... in fact I'm rather quite hazy on the
> architecture. If I remember correctly, Clip4Win apps link to the 16-bit
> DOS libraries (the same as the Clipper RDD). I don't think we have plans
> to update that code with "open file" caching. The RDD code is
> substantially different than the 32-bit code, so it would not be simple to
> port the table caching logic. It would be a rewrite.
>
>>
>> We have a big app, which in certain classes opens up to 160 tables
>> simultaneously. We have tried with a 32bit beta version of our app, and
>> we were able to run successfully the CacheOpenTables function with great
>> performance improvement.
>
> I can see why that would help you especially if there are very many
> indexes. Opening a lot of tables repeatedly can involve quite a few round
> trips to the server. Is there any way you could implement a simple form
> of the caching in your own application? I realize that it is quite a
> different task at the application level unless all table opens and closes
> are done through one single piece of code. On the other hand, it could
> probably be done "better" in the application because it could be tailored
> to meet the exact needs.
>
>>
>> Just asking... :-)
>
> No problem ... I would have asked too. :)
>
> Mark Wilkins
> Advantage R&D
>


Mark Wilkins Posted on 2009-04-16 14:42:45.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.clipper
References: <49e600b1@solutions.advantagedatabase.com> <49e60a6a@solutions.advantagedatabase.com> <49e62817@solutions.advantagedatabase.com> <49e66bca@solutions.advantagedatabase.com> <49e73aca@solutions.advantagedatabase.com>
Subject: Re: CacheOpenTables
Date: Thu, 16 Apr 2009 08:42:45 -0600
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <49e743be@solutions.advantagedatabase.com>
X-Trace: 16 Apr 2009 08:42:06 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Clipper:4403
Article PK: 1107072

Hi Jan,

No it would not be possible. Calls made into ace32.dll will not have any
affect on the 16-bit portion of the application. It works with xHarbour
because all of the calls are going through ace32.dll.

Mark Wilkins
Advantage R&D

"Jan Sperling" <sperling@racsa.co.cr> wrote in message
news:49e73aca@solutions.advantagedatabase.com...
> Hi Mark:
>
>
> I´m pretty sure you will tell me this isn't going to work, but:
> With only having access to ACE32, is there a way to get it to work
> transparently?
>
>


Jan Sperling Posted on 2009-04-16 17:44:18.0Z
Reply-To: "Jan Sperling" <sperling@racsa.co.cr>
From: "Jan Sperling" <sperling@racsa.co.cr>
Newsgroups: advantage.clipper
References: <49e600b1@solutions.advantagedatabase.com> <49e60a6a@solutions.advantagedatabase.com> <49e62817@solutions.advantagedatabase.com> <49e66bca@solutions.advantagedatabase.com> <49e73aca@solutions.advantagedatabase.com> <49e743be@solutions.advantagedatabase.com>
Subject: Re: CacheOpenTables
Date: Thu, 16 Apr 2009 09:44:18 -0800
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 190.10.50.124
Message-ID: <49e7522e@solutions.advantagedatabase.com>
X-Trace: 16 Apr 2009 09:43:42 -0700, 190.10.50.124
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!190.10.50.124
Xref: solutions.advantagedatabase.com Advantage.Clipper:4404
Article PK: 1107074

Ok, tx anyway!

--
__________________________________
Jan Sperling Frischmuth
Presidente,
Sperling Consultoría Informática S.A.

Tels:
(506)2225-9667, (506)2225-9219
(506)2253-2460, (506)2253-2473
(506)2280-6232, (506)2281-3739
Fax: (506)2281-3739
Cel: (506)8381-1488
email: jan.sperling@grecoavalon.com
web: www.grecoavalon.com

Este correo electrónico contiene información confidencial. En caso de que
usted no sea el receptor previsto, contáctenos al teléfono (506)2225-9667 o
por correo electrónico y elimine inmediatamente el mensaje.
This e-mail contain confidential information. If you are not the intended
recipient, please notify us by reply e-mail, or by telephone at
(506)2225-9667, and destroy the original message immediately.

"Mark Wilkins" <mark@no.email> escribió en el mensaje
news:49e743be@solutions.advantagedatabase.com...

> Hi Jan,
>
> No it would not be possible. Calls made into ace32.dll will not have any
> affect on the 16-bit portion of the application. It works with xHarbour
> because all of the calls are going through ace32.dll.
>
> Mark Wilkins
> Advantage R&D
>
> "Jan Sperling" <sperling@racsa.co.cr> wrote in message
> news:49e73aca@solutions.advantagedatabase.com...
>> Hi Mark:
>>
>>
>> I´m pretty sure you will tell me this isn't going to work, but:
>> With only having access to ACE32, is there a way to get it to work
>> transparently?
>>
>>
>
>