Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

DB Speed slows down

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  How to create an ODBC data source within the VB c..  
Author Message
David14

External


Since: Jan 02, 2004
Posts: 2



(Msg. 1) Posted: Fri Jan 02, 2004 7:19 pm
Post subject: DB Speed slows down
Archived from groups: microsoft>public>vb>database>odbc (more info?)

Hello,

I'm using an Access DB connecting through ODBC with ADO3.6 with VB6.0.
I open the connection once the app is running and only close the connection
once the
user closes the app. If the user updates many times, info and images(as OLE
Object) to
the db, after the 20th time, saving info, or any transaction rather slows
down
more and more until we close the app. and run it again.

Should I open the connection to the DB every time I need to update the
fields or
add new records or simply view info. and then close it again and set the
connection
object to nothing? Would this affect the apps performance? What's the
solution?

Thank in advance.
David

 >> Stay informed about: DB Speed slows down 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
HOWTO: Clone SQL db ? - Hi all, I'm having a SQL Server database called X. For testing and training, I would like to make a copy of the entire DB to Y. This copy should include all data, properties, indexes, views, etc. Unfortunately, all my attempts to automate this..

Change connect string for Excel Queries using an ODBC Driver - Reference: ODBC Connection for MAS90 MAS200 In Excel we have an ODBC Connection String with a physical (hard coded) path to the data. We have changed the servers. We do not want to recreate all of the queries. How can we edit the ODBC path inside of..

ISA 2006 with My sql Connection - Hi, Please help me,acutually I am facing problem with ISA 2006.It does not connect Mysql data base. It is giving error"Can't connect to Mysql server on "IP" 10060."

Compile Error - Can anyone please help me to solve this problem I have when I tried to compile and run my program written in VB 6.0? Problem: I used variable declaration such as db as Database and ws as Workspace. I use ODBC way to connect my VB form interface with....

ISAM driver query - Hi, I am developer in Visual Basic 6.0 and SP4 application development and database use MS Access XP and SQL 7.0. This field last 6years and I am use Clipper 5.3, 5.2(Compiler) and Foxpro 2.6, Dbase IV(Database). At now I am totaly convert in VB so I am...
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]