|
We have an App written in VC++ 6.0 and MS Access 2003 is used to store data used by the App. Initially it was good, but after the database size has grown there are serious performance issues. Is MS Access the culprit really? If then which Database should we use? It must be able to handle really massive data without compromising too much with Performance.
Awaiting your valuable suggestion and ideas.
Thanks and Regards,
Rajesh R. Subramanian
You have an apple and me too. We exchange those and We have an apple each.
You have an idea and me too. We exchange those and We have two ideas each.
|
|
|
|
|
Yeap MS-Access needs to arrested. It's not made for huge amount of data.
Suggestions:
MS-S X|L.
or
 racle
Love Forgives--Love Gives--Jesus is Love  <marquee direction="up" height="50" scrolldelay="1" step="1" scrollamount="1" style="background-color:'#44ccff'">
--Owner Drawn
--Nothing special
--Defeat is temporary but surrender is permanent
--Never say quits
--Jesus is Lord
|
|
|
|
|
It really depends on what functionality you are after. Unfortunately I can't think of any sites of hand, but to decide the best one you should decide what you need. When you say "massive data", are there lots of records or does each record contain lots of data?
Obviously size and speed is an issue, but here are some additional questions you may want to ask yourself....
Do I need rollbacks?
Do I need encryption?
What is the maximum # records I will likely need to support?
Do I need any form of referential integrity?
Do I want to pay a license for the database engine or do I want a freebie?
When I die I'd like to go peacefully in my sleep like my father, not screaming in terror like his passengers!!!
|
|
|
|
|
Thanks for the concern. I will tell you all the details.
lastgen wrote: When you say "massive data", are there lots of records or does each record contain lots of data?
There are actually lots of record. Not that each record has lots of data.
lastgen wrote: Do I need rollbacks?
Not. The database would be more like a databank from where i will keep fetching data. A very little or NO editing job will be done by the client. Something like a dictionary.
lastgen wrote: Do I need encryption?
Yes.
lastgen wrote: What is the maximum # records I will likely need to support?
Upto 10 lakhs.
lastgen wrote: Do I need any form of referential integrity?
Good if I can have. Not a problem though.
lastgen wrote: Do I want to pay a license for the database engine or do I want a freebie?
Good if a freebie can be REALLY EQUALLY good. Otherwise, ready to pay for a license.
Thanks and Regards,
Rajesh R. Subramanian
You have an apple and me too. We exchange those and We have an apple each.
You have an idea and me too. We exchange those and We have two ideas each.
|
|
|
|
|
Rajesh R. Subramanian wrote:
lastgen wrote:
Do I need rollbacks?
Not. The database would be more like a databank from where i will keep fetching data. A very little or NO editing job will be done by the client. Something like a dictionary.
If the client is not doing any editing perhaps you don't even need a database engine at all. Simple growable array(s) would possibly suffice, and you could encrypt the file(s) when you save it(them). It depends on your programming experience and capabilities really. Of the shelf database packages are usually convienient, but the may have a lot of overhead you will never use but are paying for anyway.
Unfortunately like I said before I don't know of any sites that compare database engine capabilites that I can give you. One database engine is not neccessarily always the best choice, it varies depending on what is needed(but from my experience in the past avoid Access unless you need to use a lot of macros etc).
When I die I'd like to go peacefully in my sleep like my father, not screaming in terror like his passengers!!!
|
|
|
|
|
We need to use a database here for some reason. Thanks for the reply.
Regards,
Rajesh R. Subramanian
You have an apple and me too. We exchange those and We have an apple each.
You have an idea and me too. We exchange those and We have two ideas each.
|
|
|
|
|
If the size of data is quiet large i
dont prefer growable arrays ,u cannot
realy on them . There are many issues
in a Database . If we use arrays we
need to handle all the issues and exceptions.
AS the size increases the speed is effected
No and dont try MS Access for large and
multiple user database
Let that be done by some expert database.
Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com
|
|
|
|
|
Oracle Vs MSSql^
forget Access.
"But your mind is very complex, very tricky. It makes simple things complicated. -- that's its work. And for centuries it has been trained for only one thing: to make things so complicated that your life becomes impossible."- Osho
<marquee scrollamount="1" scrolldelay="1" direction="up" height="10" step="1">--[V]--
|
|
|
|
|
If this app is kept in house where you can control the hardware, try SQL Express. We just did a long series of tests with various databases in .Net, but I imagine many of the results would apply to C++, and found that SQL Express flew through all the tests. Unfortunately, the hardware requirements for good performance are heftier than our customers will have, but if this is for in house user, look no further.
If this app is for outside customers, give CodeBase a whirl; it's an xBase based database, but holds up pretty good, and is insanely easy to use.
Anyone who thinks he has a better idea of what's good for people than people do is a swine.
- P.J. O'Rourke
|
|
|
|
|
I am using __FILE__ macro in my application.
In the debug version it returns the absolute path of the source file but in the release version it return path relative to project directory. Is this normal behaivour or am I missing something.
thanks,
-Saurabh
|
|
|
|
|
HI;
Look at the code of follow
//-----------------------------------
#ifdef _DEBUG//<-----------------NO 1
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
//-----------------------------------
so In the debug mode you can capture the absolute path and In the release mode u capture the project directory instead of absolute path
chuanke
-- modified at 1:07 Friday 6th January, 2006
|
|
|
|
|
sorry I forget to mention that this is not a MFC application. I am trying to do this in a console application.
anyway I found the solution here[^]. It says use /FC (Full Path of Source Code File in Diagnostics) to get absolute paths using __FILE__.
It seems somwhow MFC do that for you in debug but not in release build, although I don't see this switch enabled in the settings.
-Saurabh
-- modified at 2:45 Friday 6th January, 2006
|
|
|
|
|
Dear All,
Please look at the following code ...
---------------------------------------------------------------------------
PROCESS_INFORMATION pi;
STARTUPINFO si;
ZeroMemory(&si, sizeof(si));
si.cb = sizeof(si);
SetLastError(0);
CreateProcess("notepad.exe",NULL,NULL,NULL,FALSE,NULL,NULL,NULL,&si,&pi);
---------------------------------------------------------------------------
This code is not able to run the notepad because its not able to find the path of notapd.exe application.
But when I use Run option in Windows Start Menu ,type notapad and say OK, its able to find and run the notpad application may be from enviornment variables.
Please let me know why My code is not able find the notapd application?
PS- It will work if i copy notpad.exe application where my application exists.
With Regards
Manoj
|
|
|
|
|
Call
system("notepad.exe");
and refer MSDN for "system"
when u call run from start->run it work as follows ( MSDN)
The system function passes command to the command interpreter, which executes the string as an operating-system command. system refers to the COMSPEC and PATH environment variables that locate the command-interpreter file (the file named CMD.EXE in Windows NT). If command is NULL, the function simply checks to see whether the command interpreter exists.
Anil
|
|
|
|
|
Dear Anil,
Thanks you a lot for Great Help.
Thanks & Regards
Manoj
|
|
|
|
|
|
Make a call to the windows API command "GetWindowsDirectory" and use strcat to concatenate the notepad string to the end of it. You could just hardcode the string too (eg "C:\\Windows\\notepad.exe"), but if anyone has a custom windows install it may not find the file.
example code
<br />
char *strbuf[256];<br />
if (GetWindowsDirectory(strbuf, 256))<br />
{<br />
strcat(strbuf, "\\notePad.exe");<br />
}<br />
else<br />
{<br />
}<br />
<br />
CreateProcess(strbuf,NULL,NULL,NULL,FALSE,NULL,NULL,NULL,&si,π);<br />
<br />
When I die I'd like to go peacefully in my sleep like my father, not screaming in terror like his passengers!!!
-- modified at 1:18 Friday 6th January, 2006
|
|
|
|
|
Dear Lastgen,
Thanks you a lot.
Thanks & Regards
Manoj
|
|
|
|
|
manojk_batra wrote: But when I use Run option in Windows Start Menu ,type notapad and say OK, its able to find and run the notpad application may be from enviornment variables.
HKLM\Software\Microsoft\Windows\CurrentVersion\App paths.
Love Forgives--Love Gives--Jesus is Love <marquee direction="up" height="50" scrolldelay="1" step="1" scrollamount="1" style="background-color:'#44ccff'">
--Owner Drawn
--Nothing special
--Defeat is temporary but surrender is permanent
--Never say quits
--Jesus is Lord
|
|
|
|
|
Dear Owner drawn,
Thanks you a lot.
Thanks & Regards
Manoj
|
|
|
|
|
mention the full path and file name of the module which is to be executed ie., ..//notepad.exe in CreateProcess()
never say die
|
|
|
|
|
Dear sunit5,
Thanks you a lot.
Thanks & Regards
Manoj
|
|
|
|
|
hi,
how can i create an application which handles both worker and UI threads.
in MFC.
FAILURE is the first step towards SUCCESS
|
|
|
|
|
For UI thread u need tto create an object from CWinThread,
Worker thread u can use AfxBeginThread or CreateThread method
Refer MSDN
|
|
|
|
|
Dear everyone,
I have to receive a very large data from my sensor via Serial Port. Here below is the structure of my data :
10 bytes HEADER + ( 4 bytes BEGIN + 240bytes DATA )*280 + 4 byes FOOTER
=> The total byte is : 10 + ( 4 + 240 )*280 + 4 = 68334 byes !
And, with such a large data, I don't know how to receive it. My buffer always overflow !!! So, now, I want to create a independent thread for reading data out of buffer, saving to other place and free the buffer sothat it can receive other data from my sensor without overflowing. I tried search "Serial Port" on this website, and I find the article about my problem. That article is "Serial Communication in Windows", posted by Ashish Dhar. I tried to use it, but I can't succeed !
So, please kindly show me how to trap create an independent thread to achieve my purpose.
Please don't ignore my question because this is my final project for graduating from my university ...
Please help me !!! My project's deadline is coming .... I really need that code ...
Thank you very much !!!
Best regards,
Quang Dien
Email to me at : quangdien12jan@yahoo.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
