Tag Info

New answers tagged

0

One other thing to keep in mind is that you have no choice if you want to distribute non-GPL software. If you distribute software under any license but the GPL, Oracle could sue you for copyright infringement if you use their drivers.


0

The second part of this UNION adds nothing extra, remove it. That will save a table scan of ClassifiedAd (1,592,432 rows) and a DISTINCT. ( SELECT * FROM ClassifiedAd WHERE city_id = 417 AND price > 100 ) UNION DISTINCT ( SELECT c.* ...


0

Some bulk data loading tips from mysql document is possible useful. https://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-bulk-data-loading.html You can increase insert speed by some ways: - turn off autocommit - turn off unique check - turn off foreign check Hope this help !


1

Another possibility: Encode the values with Base64. Concatenate the values into a comma-separated string. Pass the resulting string. Split the string in the stored procedure. Decode the strings using Base64. Base64 encodes no comma in its default character set and either is or appears to be supported by: Oracle SQL Server Sysbase PostgreSQL MySQL ...


2

Pass the values as XML (in a VARCHAR). The following database all support shredding XML from the query language: Postgres MySQL SQL Server Oracle DB2 UDM Obviously, not every obscure database on the planet supports it. But the ones above are realistically the only ones you need to care about to hit 99.9% of the database market.



Top 50 recent answers are included