Stored Procedures - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Stored Procedures

Author

Topic

rajeshkumar77
Starting Member

46 Posts

Posted - 2001-12-12 : 20:55:09

Hai Friends

I Sql Server or in Oracle we can get the Faster performance by executing Stored Procedures.

But In MS Access I heard that We cannot execute Stored Procedures.

I have to execute these Stored Procedures from my Java Application using JDBC

Is there any way to get Faster Performance from MS Access ?

Thanks in advance

Yours
Rajesh

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-12-12 : 21:00:52

Faster performance from Access ? Use SQL Server

Sorry, there isn't a way to do it.

Damian

rajeshkumar77
Starting Member

46 Posts

Posted - 2001-12-12 : 21:06:13

Hi,
Thankyou VeryMuch

I am using Java Application to fetch the records from database
When i execute Stored procudures It is showing the records fastly.

But in access the records it is showing slowly.

Is there anyway to solve this problem

Thanks in advance
Yours
Rajesh

quote:

Faster performance from Access ? Use SQL Server

Sorry, there isn't a way to do it.

Damian

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-12-12 : 21:15:01

No, there isn't much you can do about it. SQL Server is faster than Access.

Damian

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources