Albert,
No, I have not done that. In 6.5 you could specify key columns on the attach through the menu, but that functionality has gone away in 7.x. I will try your suggestion. Thanks.
Bob C.
| Albert Berry <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 09/09/04 05:02 PM
|
|
Have you specified the indexed columns?
SATTACH <table> USING <key columns>
[EMAIL PROTECTED] wrote:
I was just reading a comment on the other list that talked about true client-server DBMS like oracle and SQL server.
It seems a lot of businesses are going to SQL server because it's Microsoft of course, but that is just a reality.
what I am having trouble with is this:
I can connect via ODBC to sql server from Rbase, attach to a million row table and try to do a search on some fields. This takes hours and sometimes just bombs out and hangs.
In access the same query takes a couple minutes or less. What can I do to try to speed up this process in R:base? Is there any plan to get tighter access to those tables or be able to read the indexes?
The same goes for oracle. Very time consuming reading large oracle views.
I worry about this only because with all the cool doo-dads and gizmos that R:base has to develop applications, I could have many nice front ends to data that is not warehoused in R:base.
Bob C
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
