• Welcome, Guest. Please login.
 
September 17, 2019, 10:00:38 am

News:

Welcome to the SQLitening support forums!


Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - James Klutho

1
MLG_PutEx global_hGrid1,sArray2(),refresh,1    'refresh must be 1

needs to be

MLG_PutEx global_hGrid1,sArray2(),op,refresh    'op needs to be 1 for your needs


Jim
2
Windows servers are becoming 64 bit only -No WoW64.  Client software will be 32 bit probably for some time with WoW64.
3
General Board / SQLitening Server in a 64bit world
July 28, 2014, 03:01:20 pm
I was think about using the 32bit SQLitening Server in a project of mine.  I'm not sure how many companies today will allow a 32bit app on their server.  Is this app already obselete?  My company would be very reluctant to load a 32 bit app on the server - I asked this morning.  Anyone with thoughts on this?
4
General Board / Re: Berkeley DB
August 05, 2013, 10:40:46 am
I downloaded the docs and looked at the C API.  I did not see where the SQLite API calls were.  From I read, I thought those were added a couple of years ago to make Berkeley DB a slick drop in replacement.  The Berkeley DB speed tests on multiuser transactions were about 5 times faster than the SQLite tests.  The commerical license is about $1800 per CPU (but free for a GNU license) but may give a need boost to the remote connections with many users.

Jim
5
General Board / Berkeley DB
August 04, 2013, 02:27:15 pm
Has anyone tried using SQLitening with Berkeley DB from Oracle.  It is suppose to be a SQLite drop-in with the advantage of finer grain locking.  Just curious.
6
General Board / Re: Is Fred OK?
February 04, 2013, 11:54:42 pm
Really sad to hear.  He only lived a couples of miles from me and I had always hoped to meet him but we never found a time to get together. Life gallups by.  He seemed to me such a good person.
7
You've got Questions? We've got Answers! / Re: Thanks
August 16, 2010, 12:53:08 am
Thanks Fred, your efforts are appreciated and I am amazed at the quality of your work and your generosity for sharing it.  You are the greatest.

Jim Klutho
8
The master table has a primary key but no index.  Counting on the primary key may help a little. Reading some forums and answers by Richard Hipp about the speed for count() is not unexpected.  Vaccuuming may help the performance.  I will continue to play with this problem to see if I can goose the speed.
9
Quote
Does count() have to walk though all the records in a database to find the 30,000 in my particular table?


No, it shouldn't. SQLite knows which table to operate based on the Master table. The Master table has a pointer to the first node in the Table that you performing the Count on. The Count should be able to quickly locate the correct Table and then process the results.

I wonder if the database has become overly fragmented from many inserts and deletes. You could try using Vacuum to put the entire database in a more optimized state.

(oops, sorry Jim, looks like I "modified" your post rather than replying to it - Paul Squires)

10
Fred

I must really have something messed up.  My 30,000 records table takes about 10 to 15 seconds with a

Select count() from master

command to process.

Your times on a 300,000 record table look great.  My table has 82 columns of text type data with one column being a primary integer key- pretty generic.  Generally my indexed selects are fairly fast.  I noticed you had a "*" in the count function which I did not.  Maybe that is my problem.


Thanks
Jim

11
I have been disappointed with the count() function speed on a table size of 30,000 records.  This function appears to work faster and it is very fast on a recount with slight alterations to the original set.  Any thoughts?

Jim




FUNCTION GetCaseCount(MyFilter AS STRING) AS LONG
    LOCAL I AS LONG
    I=0
    IF LEN (MyFilter) = 0 THEN
         slSel "select RowID from master",4
         WHILE slGetRow(4)
           INCR I
         WEND
         slCloseSet(4)
      ELSE
         slSel "select RowID from master where " & MyFilter,4
         WHILE slGetRow(4)
           INCR I
         WEND
         slCloseSet(4)
    END IF

    FUNCTION = I

END FUNCTION 

12
You've got Questions? We've got Answers! / Thanks
June 05, 2009, 04:17:20 pm
I am converting my petroleum evaluation software from a dbf database (Bullet) to SQLite/SQLightening.  I am very impressed with the results.  So far it has been a joy to use.  Fred - you have done a tremendous job on this project.  Many thanks.

Jim Klutho
13
I believe ODBC does require registery access.  If a system is locked down tight (like it is where I work), your program has to be installed by an administrator.  Probably DAO and ADO will be the same story.
14
SQLite - Beacon