RE: [sqlite] x000 line queries - only for benchmarks?
No trouble, I thought that might be the case. I am pleased I finally nailed this down. RBS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 08 February 2007 13:14 To: sqlite-users@sqlite.org Subject: RE: [sqlite] x000 line queries - only for benchmarks? No, I just forgot that this all stemmed from the original problem of sqlite_get_table throwing errors. After a while these threads all tend to get a little fuzzy to me. Sorry about that. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message -- From: "RB Smissaert" <[EMAIL PROTECTED]> > Yes, VBA supports both, but as it is just for logging purposes my solution > is fine, particularly as these long queries have repetitions of similar > elements. > > Also the function sqlite_get_table will produce an array and the error > happens directly when that function is called, so how is using a collection > or a recordset going to help me? Did you mean alter the C source code? > > RBS > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 08 February 2007 12:50 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] x000 line queries - only for benchmarks? > > Does VBA support collections? Or you could use an ADO recordset. Either > one should easily let you store elements that are over 2K bytes in length. > > -- > Eric Pankoke > Founder / Lead Developer > Point Of Light Software > http://www.polsoftware.com/ > > -- Original message -- > From: [EMAIL PROTECTED] > > There is no problem running queries of whatever > > length, so I could do benchmarks fine, it is just > > that VBA has a problem with array elements holding > > over 1823 characters. > > > > RBS > > > > > > > [EMAIL PROTECTED] wrote: > > >> In my (commercial) app I regularly have queries with over 1000 > > >> characters. > > >> Not over 1000 lines though. > > >> As VBA (not sure now about VB6) has a problem with > > >> array elements having over 1823 characters I had > > >> to truncate my SQL logging routine. > > >> > > > Under 2k? That seems a bit restrictive. No benchmarking for you then, > > > because the 25k line queries in the SQLite benchmark are nearly 2 meg. I > > > guess they're unusual but even the (more typical?) 100 liners can get up > > > to about 6-8k. > > > > > > Martin > > > > > > > > - > > > To unsubscribe, send email to [EMAIL PROTECTED] > > > > > - > > > > > > > > > > > > > > > > > > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > > > - > > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] x000 line queries - only for benchmarks?
No, I just forgot that this all stemmed from the original problem of sqlite_get_table throwing errors. After a while these threads all tend to get a little fuzzy to me. Sorry about that. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message -- From: "RB Smissaert" <[EMAIL PROTECTED]> > Yes, VBA supports both, but as it is just for logging purposes my solution > is fine, particularly as these long queries have repetitions of similar > elements. > > Also the function sqlite_get_table will produce an array and the error > happens directly when that function is called, so how is using a collection > or a recordset going to help me? Did you mean alter the C source code? > > RBS > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 08 February 2007 12:50 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] x000 line queries - only for benchmarks? > > Does VBA support collections? Or you could use an ADO recordset. Either > one should easily let you store elements that are over 2K bytes in length. > > -- > Eric Pankoke > Founder / Lead Developer > Point Of Light Software > http://www.polsoftware.com/ > > -- Original message -- > From: [EMAIL PROTECTED] > > There is no problem running queries of whatever > > length, so I could do benchmarks fine, it is just > > that VBA has a problem with array elements holding > > over 1823 characters. > > > > RBS > > > > > > > [EMAIL PROTECTED] wrote: > > >> In my (commercial) app I regularly have queries with over 1000 > > >> characters. > > >> Not over 1000 lines though. > > >> As VBA (not sure now about VB6) has a problem with > > >> array elements having over 1823 characters I had > > >> to truncate my SQL logging routine. > > >> > > > Under 2k? That seems a bit restrictive. No benchmarking for you then, > > > because the 25k line queries in the SQLite benchmark are nearly 2 meg. I > > > guess they're unusual but even the (more typical?) 100 liners can get up > > > to about 6-8k. > > > > > > Martin > > > > > > > > - > > > To unsubscribe, send email to [EMAIL PROTECTED] > > > > > - > > > > > > > > > > > > > > > > > > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > > > - > > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] x000 line queries - only for benchmarks?
Yes, VBA supports both, but as it is just for logging purposes my solution is fine, particularly as these long queries have repetitions of similar elements. Also the function sqlite_get_table will produce an array and the error happens directly when that function is called, so how is using a collection or a recordset going to help me? Did you mean alter the C source code? RBS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 08 February 2007 12:50 To: sqlite-users@sqlite.org Subject: Re: [sqlite] x000 line queries - only for benchmarks? Does VBA support collections? Or you could use an ADO recordset. Either one should easily let you store elements that are over 2K bytes in length. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message -- From: [EMAIL PROTECTED] > There is no problem running queries of whatever > length, so I could do benchmarks fine, it is just > that VBA has a problem with array elements holding > over 1823 characters. > > RBS > > > > [EMAIL PROTECTED] wrote: > >> In my (commercial) app I regularly have queries with over 1000 > >> characters. > >> Not over 1000 lines though. > >> As VBA (not sure now about VB6) has a problem with > >> array elements having over 1823 characters I had > >> to truncate my SQL logging routine. > >> > > Under 2k? That seems a bit restrictive. No benchmarking for you then, > > because the 25k line queries in the SQLite benchmark are nearly 2 meg. I > > guess they're unusual but even the (more typical?) 100 liners can get up > > to about 6-8k. > > > > Martin > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > > > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] x000 line queries - only for benchmarks?
Does VBA support collections? Or you could use an ADO recordset. Either one should easily let you store elements that are over 2K bytes in length. -- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -- Original message -- From: [EMAIL PROTECTED] > There is no problem running queries of whatever > length, so I could do benchmarks fine, it is just > that VBA has a problem with array elements holding > over 1823 characters. > > RBS > > > > [EMAIL PROTECTED] wrote: > >> In my (commercial) app I regularly have queries with over 1000 > >> characters. > >> Not over 1000 lines though. > >> As VBA (not sure now about VB6) has a problem with > >> array elements having over 1823 characters I had > >> to truncate my SQL logging routine. > >> > > Under 2k? That seems a bit restrictive. No benchmarking for you then, > > because the 25k line queries in the SQLite benchmark are nearly 2 meg. I > > guess they're unusual but even the (more typical?) 100 liners can get up > > to about 6-8k. > > > > Martin > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > > > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] x000 line queries - only for benchmarks?
There is no problem running queries of whatever length, so I could do benchmarks fine, it is just that VBA has a problem with array elements holding over 1823 characters. RBS > [EMAIL PROTECTED] wrote: >> In my (commercial) app I regularly have queries with over 1000 >> characters. >> Not over 1000 lines though. >> As VBA (not sure now about VB6) has a problem with >> array elements having over 1823 characters I had >> to truncate my SQL logging routine. >> > Under 2k? That seems a bit restrictive. No benchmarking for you then, > because the 25k line queries in the SQLite benchmark are nearly 2 meg. I > guess they're unusual but even the (more typical?) 100 liners can get up > to about 6-8k. > > Martin > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] x000 line queries - only for benchmarks?
[EMAIL PROTECTED] wrote: In my (commercial) app I regularly have queries with over 1000 characters. Not over 1000 lines though. As VBA (not sure now about VB6) has a problem with array elements having over 1823 characters I had to truncate my SQL logging routine. Under 2k? That seems a bit restrictive. No benchmarking for you then, because the 25k line queries in the SQLite benchmark are nearly 2 meg. I guess they're unusual but even the (more typical?) 100 liners can get up to about 6-8k. Martin - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] x000 line queries - only for benchmarks?
In my (commercial) app I regularly have queries with over 1000 characters. Not over 1000 lines though. As VBA (not sure now about VB6) has a problem with array elements having over 1823 characters I had to truncate my SQL logging routine. RBS > I've seen some longish SQL queries posted to this list but I was > wondering, how often do 1000+ line queries (as in the SQLite benchmark) > occur in the real world? Do queries of this sort of size exist outside > of initialising tables with a long lists of inserts? > > Martin > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > - To unsubscribe, send email to [EMAIL PROTECTED] -