make fast (query)

[narasareddy]

Hi all,
I converted one database from sqlbase to access.
It is so fast in sqlbase. But so slow in access. Taking time to run the query.
I need to make it fast.
Any help please.

 

[DCrake]

Simple Software Solutions

Why have you taken a backward step Users usually go from Access to SQL Server

CodeMaster:

 

[doco]

Are the table sizes large?
Did you bring the index definitions from SQL Server as well?

 

[asuni]

not SQL Server, It is SQLBASE.
I created index, primary key.
Now what to do please

 

[Rabbie]

You have already posted this in the Tables forum. It generally is not a good idea to multi-post. We still need more info about the data structure to help you.

 

[Guus2005]

You have already posted this in the Tables forum. It generally is not a good idea to multi-post. We still need more info about the data structure to help you.

for instance *What* is slow? Queries?
If so, please post the SQL.