Re: Which Database is best? - C / C++ / MFC Discussion Boards

First Prev Next

Re: Whacking TreeView (TreeCtrl) Info Tips

Owner drawn8-Jan-06 17:05

Owner drawn

8-Jan-06 17:05

I stand corrected. Big Grin | :-D

but how's this

TTDT_AUTOPOP - length of time the tool tip window remains visible if the pointer is stationary within a tool's bounding rectangle. Big Grin | :-D

Love Forgives--Love Gives--Jesus is Love Smile | :)

<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

-- modified at 23:06 Sunday 8th January, 2006

Which Database is best?

Rajesh R Subramanian5-Jan-06 18:40

Rajesh R Subramanian

5-Jan-06 18:40

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.

Re: Which Database is best?

Owner drawn5-Jan-06 18:42

Owner drawn

5-Jan-06 18:42

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 Smile | :)

Re: Which Database is best?

lastgen5-Jan-06 18:54

lastgen

5-Jan-06 18:54

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!!!

Re: Which Database is best?

Rajesh R Subramanian5-Jan-06 19:06

Rajesh R Subramanian

5-Jan-06 19:06

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.

Re: Which Database is best?

lastgen5-Jan-06 19:16

lastgen

5-Jan-06 19:16

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!!!

Re: Which Database is best?

Rajesh R Subramanian5-Jan-06 19:21

Rajesh R Subramanian

5-Jan-06 19:21

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.

Re: Which Database is best?

vikas amin5-Jan-06 19:22

vikas amin

5-Jan-06 19:22

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

Re: Which Database is best?

Eytukan5-Jan-06 20:23

Eytukan

5-Jan-06 20:23

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]--

Re: Which Database is best?

Joe Woodbury6-Jan-06 15:32

Joe Woodbury

6-Jan-06 15:32

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

__FILE__ macro

Saurabh.Garg5-Jan-06 18:28

Saurabh.Garg

5-Jan-06 18:28

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

Re: __FILE__ macro

Sam.Liang5-Jan-06 19:01

Sam.Liang

5-Jan-06 19:01

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

Re: __FILE__ macro

Saurabh.Garg5-Jan-06 20:42

Saurabh.Garg

5-Jan-06 20:42

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

CreateProcess!!

manojk_batra5-Jan-06 18:03

manojk_batra

5-Jan-06 18:03

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.
Smile | :)

With Regards
Manoj

Re: CreateProcess!!

Anilkumar K V5-Jan-06 18:17

Anilkumar K V

5-Jan-06 18:17

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

Re: CreateProcess!!

manojk_batra5-Jan-06 19:37

manojk_batra

5-Jan-06 19:37

Dear Anil,

Thanks you a lot for Great Help.

Smile | :)

Thanks & Regards
Manoj

Re: CreateProcess!!

ThatsAlok8-Jan-06 23:57

ThatsAlok

8-Jan-06 23:57

manojk_batra wrote:
Thanks you a lot for Great Help.

http://www.codeproject.com/system/newbiespawn.asp[^]

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers,
Alok Gupta
VC Forum Q&A :- I/ IV

Re: CreateProcess!!

lastgen5-Jan-06 18:46

lastgen

5-Jan-06 18:46

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 />
// An error occurred, perhaps the buffer is too small?<br />
}<br />
<br />
// Now you should have the full path in the strbuf variable<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

Re: CreateProcess!!

manojk_batra5-Jan-06 20:29

manojk_batra

5-Jan-06 20:29

Dear Lastgen,

Thanks you a lot.
Smile | :)

Thanks & Regards
Manoj

Re: CreateProcess!!

Owner drawn5-Jan-06 19:01

Owner drawn

5-Jan-06 19:01

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 Smile | :)