Re: Querying a MS SQL View...
RecordCount is valid only for CursorLocation=clClient, for ServerSide
cursors it depends on many factors (and underlying SQL as well). Most
probably query on View won't support cKeySet cursor type. Also in general it
was bad idea to split table. IMHO most probably yours problems were
concerned with usage of ServerSide cursors, which very badly affects
performance in multiuser environment.
.
Relevant Pages
- Re: number of connections with MSDE
... View your datamodule as text ..instead of form (the ... default) and you can do a search for "useserver" or what ever serverside ... cursors is set to. ...
(borland.public.delphi.database.ado) - Re: Grid stalling?
... query down a little, but with the resulting cursors I'm likely to get, ... > set faster as a filter. ... > grid would be faster because no filter is involved. ...
(microsoft.public.fox.programmer.exchange) - Re: SELECT TOP 10 -- then get next 10?
... If my query had a simple ORDER BY I know one way I could solve the ... database and return certain data to clients. ... to keep open cursors just incase they request the next 10 records. ... I'd prefer to stay with Access or MSSQL though. ...
(comp.databases.ms-access) - Re: A new proof of the superiority of set oriented approaches: numerical/time serie linear interpola
... Thinking procedurally (use of cursors) is inherently inferior to set ... run well in concurrent query environment and so forth. ... plans that an optimizer produces. ... for the process to run--without any negative impact on concurrency or ...
(comp.databases.theory) - SELECT TOP 10 -- then get next 10?
... I need to do a query and limit it to returning 10 rows at a time. ... database and return certain data to clients. ... to keep open cursors just incase they request the next 10 records. ... I'd prefer to stay with Access or MSSQL though. ...
(comp.databases.ms-access) |
|
