Windows Problem with RunRev/Valentina

[Dave]

Hi,

I'm working on a Demo, the 65 seconds is ok for now, we will look to  
speed it up once the pressure is off.

On windows revOpenDatabase() returns empty as the database ID.

I now have another problem I installed Valentina on the demo machine  
and ran the RunRev install Script, this seemed to work ok. However  
when I run my Test App it gives an error "revdberr,invalid database  
type". The only different that I can see that could affect it is that  
this machine also has RunRev 2.6.6.152 installed, could this be the  
cause of the problem?

Here is the RunRev code of the failing function:

--------------------------------------------------------------
--
--  LibDBOpenDatabase
--
---------------------------------------------------------------
function LibDBOpenDatabase theDatabaseFileName
   local myDatabaseType
   local myDatabaseID

   --
   --  Open the Database
   --

   put "sqlite" into myDatabaseType
   put "Valentina" into myDatabaseType

   if myDatabaseType = "sqlite" then
     put revOpenDatabase(myDatabaseType,theDatabaseFileName,,,) into  
myDatabaseID
   else
     put revOpenDatabase(myDatabaseType,"",theDatabaseFileName,,)  
into myDatabaseID
   end if
   if myDatabaseID is not an integer then
     answer error "LibDBOpenDatabase - Error from Database  
revOpenDatabase:" && myDatabaseID
     breakpoint
     return empty
   end if


  -- get revDB_execute(myDatabaseID,"PRAGMA encoding=UTF-16")

   return myDatabaseID
end LibDBOpenDatabase


Thanks a lot
All the Best
Dave

On 20 Nov 2007, at 15:00, Ruslan Zasukhin wrote:

> On 20/11/07 4:07 PM, "Dave" <dave at looktowindward.com> wrote:
>
> Hi Dave,
>
>> I am currently evaluating Valentina for RunRev. I have installed
>> RunRev and Valentina on a Mac and ran a test program that creates
>> 10,000 records, and the initial results were very promising. With
>> Valentina it takes 65 seconds to run, whereas with SQLite it takes 95
>> seconds.
>
> 65 seconds ????????
>
> This is VERY SLOW!
> Do you use SQL way?
> Do you use RevDB API or Valentina API of V4REV ?
>
> Lets check your code to see how improve it.
> Please copy paste your code here.
>
>> However, when I try to run it on Windows, the same code give an error
>> on the revOpenDatabase() call. Any idea what could be causing this on
>> Windows only?
>
> Which error?
>
> Did you check V4REV_LOG file? This may help a lots.
> If you have not it, check examples and docs about
>     Valentina_DebugLevel
>
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina