C#

bigchump wrote:

I've been trying to port my apps from VS6 to 64 bit.

bigchump wrote:

If not, can native code be compiled to 64 bit?

bigchump wrote:

So back to my question, is it possible to create a custom database with C# that is compact and runs fast?

bigchump wrote:

My database is over 20 years old and grows by about 512K every day.

bigchump wrote:

I don't know anything about SQL except that I run circles around people who do use it.

bigchump wrote:

What I don't understand AT ALL is the inability to read/write a struct/class directly to disk without a whole lot of overhead involved.

bigchump wrote:

I don't understand why the JIT compiler "chokes" (only at 64 bit, not at 32) the first time a large function is called.

bigchump wrote:

It's also likely that I've got my head screwed on backwards and am missing something simple.

Christian Graus wrote:

bigchump wrote:
My database is over 20 years old and grows by about 512K every day.


Oh, a custom format ?
Yes, a relatively small file on HD is indexed to database on tape drives to find records that match.

bigchump wrote:
I don't know anything about SQL except that I run circles around people who do use it.


Well, if you're not using SQL, you're using some specialised code written for your purpose, no surprise it may work faster than a more generalised approach ( but still impressive )

There's no comparison to SQL. I wrote all the code many years ago before SQL even existed.

bigchump wrote:
What I don't understand AT ALL is the inability to read/write a struct/class directly to disk without a whole lot of overhead involved.


Well, did C++ just write a class for you ? You can store a class the same as you did in C++, by writing code to stream the component parts, if you like. Serialisation actually works mostly for free, if you're only using simple types that know how to serialise themselves.

IF I UNDERSTAND YOU, COMPONENT PARTS MEANS WRITING ONE ITEM AT A TIME TO A BINARY FILE.
The problem with that is one of these classes has over 1500 different items.
That would mean writing 1500 lines of code to write and another 1500 to read????

bigchump wrote:
I don't understand why the JIT compiler "chokes" (only at 64 bit, not at 32) the first time a large function is called.


Because it's compiling it. Why is your function so large ? What do you mean by 'chokes' ?

I tried breaking it down into several smaller functions. It just ran slower. "Chokes" means serious delay.
Why does it choke at only 64 bits and not at 32??????

bigchump wrote:
It's also likely that I've got my head screwed on backwards and am missing something simple.


I suspect that I'm not fully understanding you just yet

bigchump wrote:

From my perspective, this whole DOT NET thing is a throwback to the old "interpeter" days with this JIT thing.

bigchump wrote:

I don't understand why the JIT compiler "chokes" (only at 64 bit, not at 32) the first time a large function is called.

bigchump wrote:

What I don't understand AT ALL is the inability to read/write a struct/class directly to disk without a whole lot of overhead involved.

bigchump wrote:

Going wrong? I don't think so.

bigchump wrote:

I never liked c++ and hate to use it but I'm becoming desperate and need some advice in the King's ENGLISH I can understand.

bigchump wrote:

run about 3000 "if" statements

        public void SerializeNow()
        {
            header c = new header();
            Stream s = File.Open(@"C:\baduga\manure.tmp", FileMode.Append);
            BinaryFormatter b = new BinaryFormatter();
            FileStream hread = new FileStream(@"c:\baduga\races.txt", FileMode.Open); //read races.txt
            StreamReader hread1 = new StreamReader(hread);
            string temp;
            string[] t = new string[1435];
            int a = 0, x = 0, y;
            while ((temp = hread1.ReadLine()) != null)
            {
                if (temp.StartsWith("JJGENDRACE"))
                {
2)                  c.entries = a;
                    b.Serialize(s, c);
1)                  for (y = 0; y
                    {
3)                      b.Serialize(s, h[y]);
                    }
                    a = x = 0;
                }
                else
                {
                    t[x] = temp;
                    if (t[x] == "")
                        t[x] = "0";
                    x++;
                    if (x == 1435)
                    {
                        if (a == 0)
                        {
                            c.track = t[0];
                            c.date = t[1];
                            c.race = t[2];
                            c.distance = int.Parse(t[5].Trim('-'));
                            c.distanceD = c.distance / 220;
                            c.surface = t[6];
                            c.type = t[8];
                            c.sex = t[9];
                            c.formtype = t[10];
                            c.purse = int.Parse(t[11]);
                            c.purseD = c.purse / 5000;
                            if (c.purseD > 50)
                                c.purseD = 50;
                            c.claimprice = int.Parse(t[12]);
                            c.trackrecord = float.Parse(t[14]);
                            c.simulT = t[20];
                            c.simulR = t[21];
                            c.breed = t[22];
                            c.poly = t[24];
                            c.par2f = int.Parse(t[213]);
                            c.par4f = int.Parse(t[214]);
                            c.par6f = int.Parse(t[215]);
                            c.parspeed = int.Parse(t[216]);
                            c.parLf = int.Parse(t[217]);
                        }
                    }
                }
            }
        }