Subject | Database Size will affect the Query Speed? |
---|---|
Author | dilish_tv |
Post date | 2005-11-14T09:19:39Z |
Dear all
Thanks for the support which u had given.
Here am coming with some more questions ..
Plsss Help
We are planning to Shift to FireBird from MS Access. we have around 40
Databases(each contatins 75 Tables).
As FireBird does not support Cross Database queries we merge all
database to a Single Fdb File
now the fdb file size is 25 GB. Is there will be any performance issues?
More queires Following :
1) What are the common pblms while Implementing FB in clients machine.
2) To secure my FireBird Database, I have created a role named
'SYSDBA' so nobody can open my database. How much secure is this?
3) How can we access FB which installed in WIN XP with service pack 1
(not SP 2).
I have add the port 3050- still I can't connect to the Server
4) While comparing with Access,
a Select Query (SELECT * FROM TABLE )which have 25 lakhs
of records coming fast in Access- (Its Taking more time in FB)-
but if the Query contains some condition FB perfoms well. Why?
5)
Thanks in Advance
Dilish
Thanks for the support which u had given.
Here am coming with some more questions ..
Plsss Help
We are planning to Shift to FireBird from MS Access. we have around 40
Databases(each contatins 75 Tables).
As FireBird does not support Cross Database queries we merge all
database to a Single Fdb File
now the fdb file size is 25 GB. Is there will be any performance issues?
More queires Following :
1) What are the common pblms while Implementing FB in clients machine.
2) To secure my FireBird Database, I have created a role named
'SYSDBA' so nobody can open my database. How much secure is this?
3) How can we access FB which installed in WIN XP with service pack 1
(not SP 2).
I have add the port 3050- still I can't connect to the Server
4) While comparing with Access,
a Select Query (SELECT * FROM TABLE )which have 25 lakhs
of records coming fast in Access- (Its Taking more time in FB)-
but if the Query contains some condition FB perfoms well. Why?
5)
Thanks in Advance
Dilish