What's the best Grid for Large SQL Databases

Todd Edmondso

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

What's the best Grid for Large SQL Databases

I need to mark 20-50 thousand records to be modified by SQL
Server, the current grid I am using supports gotobookmark and is
quite slow. What are you guys using for this. Objective, I
select 10,000 records via SELECT statement then need to write 3
or 4 changes into each record. The grid I have now takes ages
to pass the selected records back so I can process them. Any
help would be appreciated.

Todd.

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

Searche

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:What's the best Grid for Large SQL Databases

Why in the #### are you using a Grid?
Why are you returning all the data?

Is it possible to just tell the DBMS to update those records
with the info WITHOUT requesting them?

????

Quote

Todd Edmondson <toddNOtoS...@tvl.com.invalid> wrote in message

news:02e07acc.59d3bf44@usw-ex0101-008.remarq.com...

Quote

> I need to mark 20-50 thousand records to be modified by SQL
> Server, the current grid I am using supports gotobookmark and is
> quite slow. What are you guys using for this. Objective, I
> select 10,000 records via SELECT statement then need to write 3
> or 4 changes into each record. The grid I have now takes ages
> to pass the selected records back so I can process them. Any
> help would be appreciated.

> Todd.

> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!

vadi

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:What's the best Grid for Large SQL Databases

Hi,
He uses the grid because he wants a user select records in the
grid and only the selected records are updated. The problem
is with the iterating through the selected rows in the db grid
using gotobookmark. Nobody in this newsgroup knows how to speed
up the process of going through bookmarks in order to retrieve
the selected rows.

Vadim

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

Other Threads

1. Large Paradox database - What 'block size'?

2. What's the best grid?

3. As Requested: Good SQL book and Examples of SQL's LIKE statement

4. how to writing sql sentence when sentence'count is large

5. Query By Example in LARGE SQL databases

6. Delphi with large SQL databases (Oracle)

7. Problem with large BLOB in a SYBASE SQL ANYWHERE database

8. Large integer field type won't work with really larger integers

9. Best Database's for Delphi 5

10. What's the Best Database????