SQLite

Check-in [9753af5349]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Make the default TEMP_STORE=1 (TEMP tables stored on disk) in the configure script. (CVS 2748)
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 9753af53494a14f7300f92f3d94e4ceb55619529
User & Date: drh 2005-10-10 00:05:51.000
Context
2005-10-13
02:09
Attempt to fix the SQLite core so that no floating point operations are used anywhere if SQLITE_OMIT_FLOATING_POINT is defined at compile-time. This is useful to people who use SQLite on embedded processors that lack floating point support. (CVS 2749) (check-in: a0bdb58468 user: drh tags: trunk)
2005-10-10
00:05
Make the default TEMP_STORE=1 (TEMP tables stored on disk) in the configure script. (CVS 2748) (check-in: 9753af5349 user: drh tags: trunk)
2005-10-06
16:53
More efficient handling of the LIMIT clause. Scalar subqueries and EXISTS on compound SELECT statements now working properly. Ticket #1473. (CVS 2747) (check-in: edca8913ca user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to configure.
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506






# The following RCS revision string applies to configure.in
# $Revision: 1.33 $

#########
# Programs needed
#
# Check whether --enable-shared or --disable-shared was given.
if test "${enable_shared+set}" = set; then
  enableval="$enable_shared"







|







1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506






# The following RCS revision string applies to configure.in
# $Revision: 1.34 $

#########
# Programs needed
#
# Check whether --enable-shared or --disable-shared was given.
if test "${enable_shared+set}" = set; then
  enableval="$enable_shared"
19526
19527
19528
19529
19530
19531
19532
19533
19534
19535
19536
19537
19538
19539
19540
19541
19542
19543
19544
19545
19546
19547
19548
19549
19550
19551
19552





19553
19554
19555
19556
19557
19558
19559
19560
19561
# Do we want temporary databases in memory
#
# Check whether --enable-tempstore or --disable-tempstore was given.
if test "${enable_tempstore+set}" = set; then
  enableval="$enable_tempstore"

else
  enable_tempstore=yes
fi;
echo "$as_me:$LINENO: checking whether to use an in-ram database for temporary tables" >&5
echo $ECHO_N "checking whether to use an in-ram database for temporary tables... $ECHO_C" >&6
case "$enable_tempstore" in
  never )
    TEMP_STORE=0
    echo "$as_me:$LINENO: result: never" >&5
echo "${ECHO_T}never" >&6
  ;;
  no )
    TEMP_STORE=1
    echo "$as_me:$LINENO: result: no" >&5
echo "${ECHO_T}no" >&6
  ;;
  always )
     TEMP_STORE=3
    echo "$as_me:$LINENO: result: always" >&5
echo "${ECHO_T}always" >&6
  ;;





  * )
    TEMP_STORE=2
    echo "$as_me:$LINENO: result: yes" >&5
echo "${ECHO_T}yes" >&6
  ;;
esac










|



















>
>
>
>
>

|







19526
19527
19528
19529
19530
19531
19532
19533
19534
19535
19536
19537
19538
19539
19540
19541
19542
19543
19544
19545
19546
19547
19548
19549
19550
19551
19552
19553
19554
19555
19556
19557
19558
19559
19560
19561
19562
19563
19564
19565
19566
# Do we want temporary databases in memory
#
# Check whether --enable-tempstore or --disable-tempstore was given.
if test "${enable_tempstore+set}" = set; then
  enableval="$enable_tempstore"

else
  enable_tempstore=no
fi;
echo "$as_me:$LINENO: checking whether to use an in-ram database for temporary tables" >&5
echo $ECHO_N "checking whether to use an in-ram database for temporary tables... $ECHO_C" >&6
case "$enable_tempstore" in
  never )
    TEMP_STORE=0
    echo "$as_me:$LINENO: result: never" >&5
echo "${ECHO_T}never" >&6
  ;;
  no )
    TEMP_STORE=1
    echo "$as_me:$LINENO: result: no" >&5
echo "${ECHO_T}no" >&6
  ;;
  always )
     TEMP_STORE=3
    echo "$as_me:$LINENO: result: always" >&5
echo "${ECHO_T}always" >&6
  ;;
  yes )
     TEMP_STORE=3
    echo "$as_me:$LINENO: result: always" >&5
echo "${ECHO_T}always" >&6
  ;;
  * )
    TEMP_STORE=1
    echo "$as_me:$LINENO: result: yes" >&5
echo "${ECHO_T}yes" >&6
  ;;
esac



Changes to configure.ac.
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
# the corresponding code.
#
AC_INIT(src/sqlite.h.in)

dnl Put the RCS revision string after AC_INIT so that it will also
dnl show in in configure.
# The following RCS revision string applies to configure.in
# $Revision: 1.19 $

#########
# Programs needed
#
AC_PROG_LIBTOOL
AC_PROG_INSTALL








|







112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
# the corresponding code.
#
AC_INIT(src/sqlite.h.in)

dnl Put the RCS revision string after AC_INIT so that it will also
dnl show in in configure.
# The following RCS revision string applies to configure.in
# $Revision: 1.20 $

#########
# Programs needed
#
AC_PROG_LIBTOOL
AC_PROG_INSTALL

314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335




336
337
338
339
340
341
342
343
344
fi
AC_SUBST(ALLOWRELEASE)

##########
# Do we want temporary databases in memory
#
AC_ARG_ENABLE(tempstore, 
[  --enable-tempstore     Use an in-ram database for temporary tables (never,no,yes,always)],,enable_tempstore=yes)
AC_MSG_CHECKING([whether to use an in-ram database for temporary tables])
case "$enable_tempstore" in
  never ) 
    TEMP_STORE=0
    AC_MSG_RESULT([never])
  ;;
  no ) 
    TEMP_STORE=1
    AC_MSG_RESULT([no])
  ;;
  always ) 
     TEMP_STORE=3
    AC_MSG_RESULT([always])
  ;;




  * ) 
    TEMP_STORE=2
    AC_MSG_RESULT([yes])
  ;;
esac

AC_SUBST(TEMP_STORE)

###########







|














>
>
>
>

|







314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
fi
AC_SUBST(ALLOWRELEASE)

##########
# Do we want temporary databases in memory
#
AC_ARG_ENABLE(tempstore, 
[  --enable-tempstore     Use an in-ram database for temporary tables (never,no,yes,always)],,enable_tempstore=no)
AC_MSG_CHECKING([whether to use an in-ram database for temporary tables])
case "$enable_tempstore" in
  never ) 
    TEMP_STORE=0
    AC_MSG_RESULT([never])
  ;;
  no ) 
    TEMP_STORE=1
    AC_MSG_RESULT([no])
  ;;
  always ) 
     TEMP_STORE=3
    AC_MSG_RESULT([always])
  ;;
  yes ) 
     TEMP_STORE=3
    AC_MSG_RESULT([always])
  ;;
  * ) 
    TEMP_STORE=1
    AC_MSG_RESULT([yes])
  ;;
esac

AC_SUBST(TEMP_STORE)

###########