Re: Turtle like speeds connecting to db across network

>Can I use the existing database as a front end and the server as the backend?
>Will this significantly enhance my speeds?
>Should I just convert my database to SQL server?

You can use MS Access as a front end and attach the back end SQL Server tables, You might get some
performance improvement since the real number crunching is moved to SQL Server. This will happen
if the data you query is large. Setting up the attachment of SQL Server tables thru Access is
another piece of cake. It's been years since I did it and my experience is probably outdated, but
in general, it's not worth the trouble. You kind of get in a trench where you have to be a bit of
an expert of both Access and SQL Server. When things work, good, but when they don't neither
product will tell you 100% why.

I would go for the SQL Server solution and move the tables. However, if time is of the essence and
you want to get the app out and are ready to live with the perfomance you get, perhaps using the
front end / back end solution is what you should try.

>Lastly can you even use SQL Server 6.5 with the .Net framework?
Yes

/Christer

--- "Saye, Robert" <[email protected]> wrote:
> Well Christer is correct, I am using an Access 2000 database. All of the queries and inserts I
> tried to write in a reusable way. The ones that seem the slowest are the extremely complex ones.
> For instance, I have a combo box filled with supplier's names. After a selection is made, I fill
> a label with all the information about the supplier (Address, phone etc) Then I have a second
> combobox which I fill with all the contacts associated with the supplier. All in all after the
> supplier is selected, I do three queries:
> 1. Query the db for the supplier's info.
> 2. Take the state ID from the Supplier's info and run another query to get the state name.
> 3. Select all the contact's who are associated with this supplier.
> Then I push all the info into a label below the combobox.
>
> On my development computer, this is almost instantaneous. When I moved to the network, there is
> a noticeable pause while this takes place( The 1:10 may have been an exaggeration... but not
> much of one).
>
> So here are a few other questions, we have an SQL Server 6.5 here that I could probably use some
> space on. (You may have figured out by now that I don't normally do this :)) Can I use the
> existing database as a front end and the server as the backend? Will this significantly enhance
> my speeds? Should I just convert my database to SQL server? Lastly can you even use SQL Server
> 6.5 with the .Net framework? As a small company, we don't have a DBA here. I am actually the
> only person in the company who has read a single book on databases. So our IT guy is in charge
> of it. He really doesn't know how to use it, so I have to go to him with a solution not a
> problem.
>
> Again,
>   Thank you for your time.
> Robert Saye
>
> -----Original Message-----
> From: Phil Allan-Harding [mailto:[email protected]]
> Sent: Friday, October 04, 2002 8:40 AM
> To: [email protected]
> Subject: Re: [OLEDB_DEV] Turtle like speeds connecting to db across
> network
> Importance: High
>
>
> Thats rather surprising (10x), it depends a lot on:
>
> - The DB schema
> - The type & syntax of your DML (selects, inserts etc)
> - The data access interface being used by client(s) (ADO, OLEDB, ODBC etc)
>
> How you can optimise a schema is largely dependent on the RDBMS for it's
> "optimisation rules"
> Design the schema/parts of the schema with it's intended purpose in mind
> (OLAP, OLTP)
> Don't blindly follow the normalisation rules, doing so can have a
> deletorious effect
> Bear in mind that the use of SPs, in performance terms, can outstrip DML in
> some circumstances
> Match the solution to the requirement
> Read the RDBMS documentation sections concerning performance thouroughly
>
> X------X SNIP
>
> You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
> or subscribe to other DevelopMentor lists at http://discuss.develop.com.


__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.