SQL Server question 
Author Message
 SQL Server question

Hi,

I work for a company with a quite successful BDE based product.  We a fast
approaching the practical size limits of Paradox and I'm attempting to learn
SQL Server inorder to convert.  Please excuse me if this question seems
silly or quite basic :

I have a table which is expected to hold between 1 and 1.5 million records,
e.g. representing customer details.  I wish to display this table as a grid,
but the problem I have is using a Client side cursor all the records are
returned accross the network, which can take some time.

When using SQL Server Enterprise Manager to view a table using "Return all
rows" option, it seems to grab the first 1000 or so and as you scroll down
it grabs the next 1000 or so from accross the network.  This works really
well so I was wondering if there is any way to replicate this functionality
in Delphi.

Can anyone help please ???



Wed, 18 Jun 1902 08:00:00 GMT
 SQL Server question


Quote:
>Hi,

>I work for a company with a quite successful BDE based product.  We a fast
>approaching the practical size limits of Paradox and I'm attempting to
learn
>SQL Server inorder to convert.  Please excuse me if this question seems
>silly or quite basic :

>I have a table which is expected to hold between 1 and 1.5 million records,
>e.g. representing customer details.  I wish to display this table as a
grid,
>but the problem I have is using a Client side cursor all the records are
>returned accross the network, which can take some time.

>When using SQL Server Enterprise Manager to view a table using "Return all
>rows" option, it seems to grab the first 1000 or so and as you scroll down
>it grabs the next 1000 or so from accross the network.  This works really
>well so I was wondering if there is any way to replicate this functionality
>in Delphi.

>Can anyone help please ???

The BDE fetches all rows from a query to the front-end cache without making
use of server side cursors, which is the preferred way of doing things if
you
are going to browse a lot of rows. For this reason (and some others) I don't
use
the BDE but ODBCExpress which gives you direct, native access to SQL
Server via ODBC.

Do yourself a favour and have a look at www.odbcexpress.com.

Julian van Tubbergh.

PS: I don't use the Enterprise edition of Delphi so I haven't tried the new
ADO components. They might work just as well, but I can't comment on
them. Anyway, the premium in price you pay for the Enterprise edition
does not seem to justify it, if you compare it to Delphi Pro + ODBCExpress.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Server Question from Access SQL User

2. SQL Server Question from someone with no SQL expierence

3. HELP!HOW TO SLOVE THIS SQL SERVER QUESTION?

4. Upsizing from Access to SQL Server question...

5. Some SQL server questions

6. Newbie to SQL Server question - select w/ order by

7. Some SQL server questions

8. Not really SQL Server question, but ..

9. SQL Server Question

10. SQL Server Question :: Triggers Perhaps?

11. SQL Server Question

12. SQL Server Question


 
Powered by phpBB® Forum Software