[EQ] About Ado managing !?
- From: "Ahmadi" <ahmadisolness_b@xxxxxxxxx>
- Date: Sun, 25 May 2008 21:34:39 +0430
Hi
Im using MSAccess(.mdb) and Microsoft Jet driver 4 and Ado and D7 and XP SP3
and CPU ~10 Ghz
Im trying to keep 100,000 records in my database and retrieve data from it,
just a simple work for general DBMS.
but when i try to run a simple query (with ADOQuery), i must wait for 3
seconds! really why!?
here is my query:
Select top 100 * from bank where LFName like 'Ahmadi%' and
(Visibility=1) order by LFName;
Note: I have one index on LFName in my database.
Note: Maybe you think 3 second is good, but im using this search for
autocomplete system and user typing(with keyboard) is not user friendly and
user think that system is hanged!
Its incredibles for me that MSAccess have problem with 100,000 records(each
record size=50 bytes)!
i think that i have a problem, not Access.
Answering to following question can help me:
1)how can i make a clustered index in MSAccess database such as SQL Server
that support clustered index.
2)in the above story, Ado is weak or DBMS or me ? don't forget the above
strategy work fine with SQL Server(clustered index).
3)are there any tricks about Ado Query and MSAccess that help me.
4)how can i say to one readonly Ado Table to keep whole of database in RAM?
Thanks for any help
--
~~~~~~~~~~~
Best Regards
H.Ahmadi
.
- Prev by Date: ADO, ShortDateFormat and Terminal Services/Citrix
- Next by Date: Re: ADOQuery Command Text does not return a result set
- Previous by thread: ADO, ShortDateFormat and Terminal Services/Citrix
- Next by thread: Exporting ADOQuery Results to Excel
- Index(es):
Relevant Pages
|
