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.

How do i fetch fast data from web server

3 posts in General Discussion Last posting was on 2004-02-12 19:44:02.0Z
Chandresh Patel Posted on 2004-02-12 18:38:12.0Z
Sender: 5942.402bca90.1804289383@sybase.com
From: Chandresh Patel
Newsgroups: ianywhere.public.general
Subject: How do i fetch fast data from web server
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <402bcaa8.5945.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 12 Feb 2004 10:49:12 -0800, 10.22.241.42
Lines: 14
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Feb 2004 10:20:08 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Feb 2004 10:38:12 -0800
X-Trace: forums-1-dub 1076611092 10.22.108.75 (12 Feb 2004 10:38:12 -0800)
X-Original-Trace: 12 Feb 2004 10:38:12 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2470
Article PK: 5607

Hi,

I develop one application in c# using sybase anywhere studio
ver 9.0. finally I put my database in to web and try to
access usign odbc from my local machine. (My local machine
is connect with internet).

I create one report and to display it data it take almost 4
minuts.

Now help me is there any way to get all data from server and
process locally OR how can i directly work with
AsaDataReader (Is any easy way to transfer data from
AsaDataReader to DataTable.)


Chris Keating (iAnywhere Solutions) Posted on 2004-02-12 19:18:14.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <402bcaa8.5945.846930886@sybase.com>
Subject: Re: How do i fetch fast data from web server
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <402bd406$1@forums-2-dub>
X-Original-Trace: 12 Feb 2004 11:29:10 -0800, keating-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Feb 2004 11:00:05 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Feb 2004 11:18:14 -0800
X-Trace: forums-1-dub 1076613494 10.22.108.75 (12 Feb 2004 11:18:14 -0800)
X-Original-Trace: 12 Feb 2004 11:18:14 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2473
Article PK: 5609

You mean that you are running your database file on a network server and
connecting to that server?

This doc may help

http://www.ianywhere.com/developer/technotes/sqlany_wan.html

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

<Chandresh Patel> wrote in message
news:402bcaa8.5945.846930886@sybase.com...
> Hi,
>
> I develop one application in c# using sybase anywhere studio
> ver 9.0. finally I put my database in to web and try to
> access usign odbc from my local machine. (My local machine
> is connect with internet).
>
> I create one report and to display it data it take almost 4
> minuts.
>
> Now help me is there any way to get all data from server and
> process locally OR how can i directly work with
> AsaDataReader (Is any easy way to transfer data from
> AsaDataReader to DataTable.)


Chandresh Patel Posted on 2004-02-12 19:44:02.0Z
Sender: 5d88.402bd6ed.1804289383@sybase.com
From: Chandresh Patel
Newsgroups: ianywhere.public.general
Subject: Re: How do i fetch fast data from web server
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <402bd782.5d92.846930886@sybase.com>
References: <402bcaa8.5945.846930886@sybase.com><402bd406$1@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Feb 2004 11:44:02 -0800
X-Trace: forums-1-dub 1076615042 10.22.241.41 (12 Feb 2004 11:44:02 -0800)
X-Original-Trace: 12 Feb 2004 11:44:02 -0800, 10.22.241.41
Lines: 65
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2474
Article PK: 5611

You are right. I am talking about network server and if i
pass one query like "Select * from dactivity" and it fetch
16000 record in one second in AsaDataReader but now I want
to use or convert this datareadr to DataTable in C# or if
any other way to pass some query in this data to fetch few
data from them

> You mean that you are running your database file on a
> network server and connecting to that server?
>
> This doc may help
>
>
http://www.ianywhere.com/developer/technotes/sqlany_wan.html
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> **********************************************************
> ****************** *
> Sign up today for your copy of the SQL Anywhere Studio 9
> Developer Edition and try out the market-leading database
> for mobile, embedded and small to medium sized business
> environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> **********************************************************
> ****************** *
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at
> http://www.iAnywhere.com/developer ** EBFs can be found at
> http://downloads.sybase.com/swx/sdmain.stm ** Use
> CaseXpress to report bugs http://casexpress.sybase.com
>
> **********************************************************
> ****************** *
>
> <Chandresh Patel> wrote in message
> news:402bcaa8.5945.846930886@sybase.com...
> > Hi,
> >
> > I develop one application in c# using sybase anywhere
> > studio ver 9.0. finally I put my database in to web and
> > try to access usign odbc from my local machine. (My
> > local machine is connect with internet).
> >
> > I create one report and to display it data it take
> > almost 4 minuts.
> >
> > Now help me is there any way to get all data from server
> > and process locally OR how can i directly work with
> > AsaDataReader (Is any easy way to transfer data from
> > AsaDataReader to DataTable.)
>
>