LOW speed in opening Access database !
-
Hi there, I’m writing a database project … I used Access database … I have 50925 records in this database … My program is very LOW in opening that in starting up (8 seconds) Is there any way to improve the SPEED of opening the database ?!!!!!!!!! NOTICE: I connected to database by ADO (OLEDB JET 4.0). Regards, My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
-
Hi there, I’m writing a database project … I used Access database … I have 50925 records in this database … My program is very LOW in opening that in starting up (8 seconds) Is there any way to improve the SPEED of opening the database ?!!!!!!!!! NOTICE: I connected to database by ADO (OLEDB JET 4.0). Regards, My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
What about using MSDE instead?
int x=1, y=5;
x^=y^=x^=y; // whats the content of x and y now?
ClickHereForHelp(); -
What about using MSDE instead?
int x=1, y=5;
x^=y^=x^=y; // whats the content of x and y now?
ClickHereForHelp();MSDE ??? what is it ???????? I really didn't hear anything about it !!!! Could you explain about it ??? :wtf: My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
-
MSDE ??? what is it ???????? I really didn't hear anything about it !!!! Could you explain about it ??? :wtf: My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
Hadi_Rezaie wrote: MSDE ??? I think desktop version of SQLServer.I don't think it helps you. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors Down
-
MSDE ??? what is it ???????? I really didn't hear anything about it !!!! Could you explain about it ??? :wtf: My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
MSDE stands for Microsoft Desktop engine. It´s a light version of SQL Server, this version comes without the graphical administrative tools. Follow the Link: http://www.codeproject.com/useritems/JetMSDE.asp
-
Hadi_Rezaie wrote: MSDE ??? I think desktop version of SQLServer.I don't think it helps you. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors Down
Yes, it is the desktop SQL engine. Since it is quite a bit faster it might well help.
int x=1, y=5;
x^=y^=x^=y; // whats the content of x and y now?
ClickHereForHelp();