[sqlite] Collate

Hi, is there any implications on performance of using collate i(NOCASE for example) in the column definition when creating a table? doesn't it effect the indexes use of those columns? when using collate NOCASE on some column definition, how does a specific element is chose to be returned, the

Re: [sqlite] Re: Collate

[EMAIL PROTECTED] wrote: Aviad Harell [EMAIL PROTECTED] wrote: is there any implications on performance of using collate i(NOCASE for example) in the column definition when creating a table? doesn't it effect the indexes use of those columns? If you also create an index on this column

Re: [sqlite] Re: user defined function

, (SUM(SALES)) AS [SUM_SALES] FROM Test1MX1000Multi AS T1 GROUP BY CUSTOMER, PRODUCT) AS [T1]) AS [TEMP] WHERERANK = 4 ORDER BY CUSTOMER, RANK On 10/8/07, Igor Tandetnik [EMAIL PROTECTED] wrote: Aviad Harell

[sqlite] user defined function

Hey, I tried to create user defined function called Rank. which gets partition columns and order by column. this function should create rank according to its parameters. i.e.: select customer, product, sales, Rank(customer, sales) from table should return: customerA productA 100 0 customerA

[sqlite] multiple connections

Hi, Regarding only to select statements, is there a known limit of number of concurrent connections to Sqlite DB? What about concurrent connections to the same table in the sqlite DB? Regards, Aviad

[sqlite] Query Help

Hi, I Have a problem with the following query executed on sqlite SELECT CUSTOMER, PRODUCT, [RANK] FROM (SELECT CUSTOMER, PRODUCT, [SUM_SALES], (SELECT COUNT(T2.SUM_SALES) FROM (SELECT CUSTOMER,