Jet ISAM vs. SQL Server architecture question 
Author Message
 Jet ISAM vs. SQL Server architecture question

I have implemented serveral appications using Microsoft JET engine.
Navigating in a list (DBGrid with Data Control) with 50.000 or even 100.000
records causes no problems. Moving the scrollbar to skip 30.000
records, for instance, is done immediatly.

No I want to use a SQL Server (Sybase SQL Anywhere)

I have made a test application with a Remote Data Control and a DBGrid.
I have list of 40.000 records ("select * from customer;")
When I want to get to the middle of the list (skipping 20.000 records)
I have to wait about 20 seconds to get a result.

Do I have the wrong (ISAM-oriented) architecture?
Do I have to limit the resultset to a few hundret records?
Am I using a bad ODBC driver or SQL server?


Fri, 06 Apr 2001 03:00:00 GMT  
 [ 3 post ] 

 Relevant Pages 


2. Access vs SQL Server vs Sybase vs Oracle

3. Jet 3.51 vs Jet 4.0 vs MSDE

4. SQL vs JET - SQL Statement Syntax

5. Design Question: Call .dll from SQL Server VS MTS

6. Newbie Question: Access vs SQL Server

7. Access vs SQL Server - 4 questions

8. Design Question: Calling .dll from SQL Server VS MTS

9. Jet DB Performance (Jet 3.51 vs. Jet 4.0)

10. SQL for both JET and SQL Server

11. Converting SQL Server/MSDE code to Jet SQL

12. Client/Server Architecture Question


Powered by phpBB® Forum Software